topic count the count in QlikView

count the count

Tue, 18 May 2010 09:20:49 GMT

Hello,

i have the attached file,

It displays the count of each ID has.
How can i further to calculate how many IDs are having the count of 1, 2, etc?

i can easily do this in excel pivot. i'm not sure how in QV.

If someone is able to show it in the file, that'd be great.

Thanks

count the count

Tue, 18 May 2010 09:38:36 GMT

see this

Thanks

zaman

count the count

Tue, 18 May 2010 10:46:31 GMT

Count({$<Count={1}>}Count) and Count({$<Count={2}>}Count)

First expression will show the count of id's which have 1 as count and second expression which shows the Count of id's which have 2 as count.Count({$<Count={1,2}>}Count) which will displays the sum of count of id's which has either 1 or 2 as count .

count the count

Tue, 18 May 2010 11:48:19 GMT

Hi Zaman,
Good suggestion, but i overlooked one thing. The count column in my souce is actually a count(), but in the example, i hardcoded the count result. and when i do count(col1) in Dimension tab, it doesnt work.

Hi Naive,
We are still on v8, set doesnt work for us. but i'll try as soon as v9 is up.
Thanks.