Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

aggr function

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

6 Replies
swuehl
MVP
MVP

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))

Not applicable
Author

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

swuehl
MVP
MVP

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

Not applicable
Author

hi

the problem is resolved.

thanks..

antrtiz001
Partner
Partner

Hi,

I've the same kind a problem.

Could you please describe the way you solved yours?

Thanks in advance

Antonio

Not applicable
Author

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.