New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Highlighted
New Contributor

Sum(Count) Function

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.

Tags (2)
1 Solution

Accepted Solutions MVP & Luminary

Re: Sum(Count) Function

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

- Marcus

5 Replies
Contributor

Re: Sum(Count) Function

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)

Valued Contributor III

Re: Sum(Count) Function

hello

if you want to sum the values, use

sum([Count of Store])

your formula sums the number of distinct values MVP & Luminary

Re: Sum(Count) Function

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

- Marcus

New Contributor

Re: Sum(Count) Function

İts work. Thank you so much Contributor

Re: Sum(Count) Function

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.