Discussion board where members can get started with QlikView.
I want to sum count of country.
I want Sum(Count of Store) = 48 but Sum(Count( DISTINC Store)) is not working.
Try it with: Sum(aggr(Count( DISTINC Store), Week))
View solution in original post
Count DISTINCT only finds the number of stores ...not the the total of stores
Count(DISTINT Store) = 7, this is correct as there are only 7 distinct stores
If you wish to sum the store, you will need to add a separate expression Sum(Store)
if you want to sum the values, use
sum([Count of Store])
your formula sums the number of distinct values
İts work. Thank you so much
@okanakdemirci @marcus_sommer @olivierrobin @ljackson
Hello, I have a similar question on this forum:
I was wondering how could I Sum the Count of several different values (by specifying which ones I want to Sum) to obtain the total percentage in a pie chart.
Does anyone here know how to help? I would really appreciate it.