Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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
Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

5 Replies
Highlighted
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)

Highlighted
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

Highlighted
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

Highlighted
Contributor
Contributor

İts work. Thank you so much

Highlighted
Creator
Creator

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