topic Count from Straight Table in QlikView

Count from Straight Table

kenji_khoo — Wed, 15 Jul 2020 04:56:24 GMT

Dear all experts,

Please refer to the table below:

I can simply do a count(Detail No) to get the column 3. But in column 4, I would like to have total count of Detail No by Group No. I tried aggr(count(Detail No),Group No), it doesn't work.

Group No	Detail No	Count Detail No by Group No	Total Count of Detail No
		4
200270313	10	1	4
200270313	20	1	4
200270313	30	1	4
200270313	40	1	4

Re: Count from Straight Table

tresB — Wed, 15 Jul 2020 05:31:39 GMT

Try:

count( total [Detail No])

count( total <[Group No]> [Detail No])

Re: Count from Straight Table

Lisa_P — Wed, 15 Jul 2020 05:38:20 GMT

It is giving you what you ask for.

What are you expecting to see ?