Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

Issue with AGGR(field,field)

Hi All,

I have used AGGR(City,City) to hide the grey out values from Filter Pane but the concern over there is after using this expression I am not able to select the multiple values at a time.

Here I am not able to select multiple values at a time like City A and City D

For eg.

City Country

A      1

B       2

C       3

D      4

Or is there any other alternative to remove the grey out values from Filterpane.

Note: AGGR(City,City) is working in Qlikview (Listbox) but not in Qlik sense(filterpane). In Qlikview I am able to select multiple alternate values using ctrl button but not in Qlik Sense.

Can this be a bug?

Labels (1)
2 Replies
JustinDallas
Specialist III
Specialist III

What does "AGGR(field,field)" actually say from a function standpoint?  I'm used to seeing AGGR(AggregateFunc, SomeDimension).

Qlik1_User1
Specialist
Specialist
Author

AGGR(field,field) it will hide the grayed out values..