Discussion board where members can get started with Qlik Sense.
I have a dataset of sales from different Stores and those related to the customers ID, product Id and so on... and I need to be able to SUM the number shops that have made any sales per day.
I have 100 Stores (Maximum)
If I use the function COUNT (Distinct "Store Name) the result will depend on the dimension, so:
For this Example supose that The month only have "3 Days"
Day Month Count (Disntinct "Store Names")
1 1 100
2 1 95
3 1 80
If I take out Dimension Day from the above table, then Count (Distinct "Store Names") will take account the month as a whole and the result will be 100.
Month Count (Disntinct "Store Names")
- I need to get the sume of Number Stores Open Every Day: 100 +95 +80 Regardless of the dimension I use, I need this function to be limitd to count per day dimension.
Go to Solution.
=Sum( Aggr( Count(DISTINCT "Store Names"), Month, Day))
edit: and if you Need to ignore your Chart dimensions:
=Sum(TOTAL Aggr( Count(DISTINCT "Store Names"), Month, Day))
Thanks very much Stefan for you help!!!
It was quite helpful!!!