Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
keitel2015
Contributor III
Contributor III

Count negative customer and display the last 12 month

Hi,

I am looking for the correct formula for my problem. I want to create a bar chart which displays the number of negative customer (based on profit). The bar chart should displays the last 12 months. My fields are: [Fiscal Date], [Customer ID] and Profit. I have a solution if I added the [Customer ID] dimension too but I need a solution without [Customer ID] dimension. My current formula is this: Count({1} DISTINCT [Customer ID]).

test.PNG

11 Replies
keitel2015
Contributor III
Contributor III
Author

Thank you very much ! That is exactly what I needed.

What is the best way to display only the last 12 month and not the whole fiscal dates? Calculated dimension or set analysis in the expression?

sunny_talwar

If there are multiple expressions, I will go with a calculated dimension, if there is only one expression, then set analysis would make more sense.

HTH

Best,

Sunny