topic AGGR Count in QlikView

AGGR Count

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

I've got a straight table where I want to do a count to get the total for one dimension:

Dim 1 Dim 2 Dim 3 Dim 4 Count Required Column

A B C E 10 15

A B D E 5 15

I want to get a total count for the table. I've tried:

= AGGR(COUNT( DISTINCT Field),Dim1, Dim2, Dim4)

This works for the first line in the table, but then I just get a blank for the second.

Does anyone know of a solution?

Re: AGGR Count

Anonymous — Wed, 10 Jun 2020 14:21:46 GMT

Try the following:

=SUM( AGGR(COUNT( DISTINCT Field),Dim1) )+SUM( AGGR(COUNT( DISTINCT Field),Dim2) )+SUM( AGGR(COUNT( DISTINCT Field),Dim3) )+SUM( AGGR(COUNT( DISTINCT Field),Dim4) )

Re: AGGR Count

aliyoung92 — Wed, 10 Jun 2020 14:38:17 GMT

Unfortunately just gives a 0 rather than a blank for the other rows