filters only show possible value

[ronaldwang]

in Qliksense filters panel , all values within a dimensions will be shown, (possible value in white and not possible value in grey). is there a way to get rid of the grey value so only possible value will be shown?

[Rodj]

Hi @ronaldwang ,

I don't think that there's any way to do this currently, it would kind of defeat the purpose of the associative approach by hiding values that it might be useful to know. You can list the possible values and view them in a text box:

concat([Your Field], ',')

but they won't be selectable. I think I've seen something like this done with a widget, but not with the standard objects.

This is where someone comes along and proves me wrong hopefully!

[rwunderlich · Accepted solution]

In the filterpane, use a dimension expression like:

=Aggr(MyField, MyField)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com