topic aggr function in QlikView

aggr function

Mon, 26 Jan 2026 18:19:17 GMT

Hi friends

i am using aggr function and set analysis to prepare an expression and its working fine but its working only on selection of dimension. I want that data should be shown without selection of dimension .

my expression is : =aggr(Count( DISTINCT {<CODE-= {'000','001'} >} [ID]),Circle)

Here i have 'Circle' as Dimension. Expression value is displayed only when i select the Circle. I want the Expression values without Selecting Circle.

Can anyone help me in this????

Thanks

Ankit

aggr function

swuehl — Tue, 03 Apr 2012 11:43:48 GMT

For more than one possible Circle, you will get multiple values returned.

You need to aggregate these values to get one unambiguous value returned, I would use a sum:

=sum(aggr(Count( DISTINCT {<CODE-= {'000','001'} >} [ID]),Circle))

aggr function

Tue, 03 Apr 2012 11:48:16 GMT

using sum will give me sum of count(ID) for all the Circles without selecting any Circle.

I dont want the sum of Count values..

aggr function

swuehl — Tue, 03 Apr 2012 13:15:18 GMT

Ok, what do you want / expect then? Can you give an example?

aggr function

Wed, 04 Apr 2012 10:46:36 GMT

the problem is resolved.

thanks..

aggr function

antrtiz001 — Sat, 14 Apr 2012 06:35:19 GMT

Hi,

I've the same kind a problem.

Could you please describe the way you solved yours?

Thanks in advance

Antonio

aggr function

Thu, 19 Apr 2012 09:10:02 GMT

hi Antonio

i used if condition with Total fnc.

eg:

if(CODE<>'000' or '001',Count(TOTAL<Circle>ID))

add all the dimensions in the <> for which u want the count.