Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum(Count) Function

Hi All,

I want to sum count of country.

For Example,

  

WeekQtyCount Of Store
106
2018-0113
2018-0203
2018-0303
2018-0433
2018-0506
2018-0606
2018-0716
2018-0806
2018-0956
2018-1006

I want Sum(Count of Store) = 48 but Sum(Count( DISTINC Store)) is not working.

Please Help,

1 Solution

Accepted Solutions
marcus_sommer

Try it with: Sum(aggr(Count( DISTINC Store), Week))

- Marcus

View solution in original post

5 Replies
ljackson
Creator
Creator

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)

olivierrobin
Specialist III
Specialist III

hello

if you want to sum the values, use

sum([Count of Store])

your formula sums the number of distinct values

marcus_sommer

Try it with: Sum(aggr(Count( DISTINC Store), Week))

- Marcus

Anonymous
Not applicable
Author

İts work. Thank you so much

ritaaguiar
Creator
Creator

@Anonymous @marcus_sommer @olivierrobin @ljackson 

 

Hello, I have a similar question on this forum:

https://community.qlik.com/t5/New-to-Qlik-Sense/Display-Pie-Chart-with-the-Count-of-some-data-values...

 

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.