topic Re: Sum(Count) Function in QlikView

Sum(Count) Function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want to sum count of country.

For Example,

Week	Qty	Count Of Store
	10	6
2018-01	1	3
2018-02	0	3
2018-03	0	3
2018-04	3	3
2018-05	0	6
2018-06	0	6
2018-07	1	6
2018-08	0	6
2018-09	5	6
2018-10	0	6

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

Please Help,

Re: Sum(Count) Function

ljackson — Wed, 04 Jul 2018 13:38:48 GMT

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)

Re: Sum(Count) Function

olivierrobin — Wed, 04 Jul 2018 13:40:01 GMT

hello

if you want to sum the values, use

sum([Count of Store])

your formula sums the number of distinct values

Re: Sum(Count) Function

marcus_sommer — Wed, 04 Jul 2018 13:40:57 GMT

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

- Marcus

Re: Sum(Count) Function

Anonymous — Wed, 04 Jul 2018 14:14:18 GMT

İts work. Thank you so much

Re: Sum(Count) Function

ritaaguiar — Tue, 23 Apr 2019 09:25:42 GMT

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