Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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..