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: 
luisccmm
Creator
Creator

Count distinct Stores Openend per Day - Regardless of Time Dimension

Hi,

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")

1         100

1         95

1         80

Expected Result:

- 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.

Any help???

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

=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))

View solution in original post

2 Replies
swuehl
MVP
MVP

Maybe like

=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))

luisccmm
Creator
Creator
Author

Thanks very much Stefan for you help!!!

It was quite helpful!!!