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