Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What does "AGGR(field,field)" actually say from a function standpoint? I'm used to seeing AGGR(AggregateFunc, SomeDimension).
AGGR(field,field) it will hide the grayed out values..