Hi,

Can you kindly help me understand how to apply distinct count for the following expressions,

count(distinct{<[Price check]={"=If((sum([Dealer Sell-in price])-[Unit Price (EUR)])>0,'N','Y')"}>}[Part Number])

In the above expression,  , Unit Price = sum(Price * Exchange
)/sum(Quantity), Price check=If((sum([Dealer Sell-in price])-([Unit Price (EUR)]))>0,'N','Y'))

Currently, the formula is making distinct count on all the part number but I need it distinct count only the [Part Number] with [Price check] is 'Y' for each Dealer.

Let me know if you need any other details from me.

Thanks in advance

I have been provided with api documentation with below details:

URI scheme: testurl.com

Schemes:HTTPS

Security

APIKeyAuth

Type:apiKey

Name:x-api-token

In: Header

Path:

POST /api/test/upload

Parameters:

Type: FormData

Name: file

Schema: file

Consumes: mutipart/form-data

Produces: application/json

With the help of the above details i am able to successfully configure in postman and recieved response code 200

But When i tried in Talend using trestclient I get below error:

Payload: {"status":"ERROR","message":"Failed to parse multipart servlet request"}

The have provided all the screenshot for reference.

Could anyone please help me to resolve the issue..

Hallo Zusammen,

wir haben seit dem Update auf Version "Feb. 2024" (inkl. Patch 4) ein Problem bei der Abfrage von MySQL Daten. Sobald in Abfragen im Spaltenname ein Unterstrich "_" vorhanden ist, liefert Qlik leere Daten in dieser Spalte zurück.

Auch den Spaltenname in der Abfrage zu maskieren [auftrag_position_id] bringt keine Verbesserung.

Für eure Unterstützung wäre ich euch dankbar!

Hi,

For some project requirements we have to migrate some qlikSense application to Power Bi.

Looking for some best practice documentation and some Guidance documents. 

If someone can share what are the blockers we might encounter, would help us in planning.

Thanks in advance.

Hello Experts, 

I want to evaluate the column Value to use it in Bell Curve, I do not want to use qlik NormalDist function.

I am facing issue in evaluating the Vlaue column as in Value column, First row should have abs(99.7%Low) colum and the consucutive rows will have row1 then the cumulative sum by adding Gap values in it. So the first row remain as it is and the cumulative sum by adding GAP from second row onwards. I am attaching the excel as a sample data and the Value column have the excel formula to replicate in qlik. I am using qliksense web version so please paste the expression and will not be able to open the qvf file as do not have desktop version.

Thanks in advance

Hi Guys，

On the line chart, you can only choose to show all data points label or not show label. Can you hide the labels from January to September? Only shows 10-12 months, or is there a better extension? except vizlib.

Thanks!!

Hello everyone, 

how can i make this formula work? 

i want to set specific colours based on a calculation, i dont like the ones i get by default in qlik sense. This is for a bar chart. 

if (Sum([profit22]) - Sum([profit21]) > 0 ; color = #87205d, color= #ac4d58)

thanks!

Hi,

We are using Qlik Application Automation to schedule a chain of reloads and have recently experienced some undocumented behaviour from the Call Automation block. It randomly fails with: Error calling endpoint "Qlik Cloud Services - Start Reload". The failure is exactly 40 minutes and 48 or 49 seconds after start. No other details are provided.

Any ideas are appreciated as this error stops the whole chain and sets our data back by a whole day.