Sheet action to exclude a value.

[ferha_jafri]

Hello Experts,

I am surprised, as it was very easy in qlikview but not sure why not working in qliksense. I want to add an action on sheet to exclude one value in a field but not able to find the exact solution.

Thanks in advance

Ferha 

[Pierrick · Accepted solution]

Hi,

One possible solution is to use "Select values in a field" action, and set Value to : 

=concat({<[Field Name]-={'ValueExclude'}>} distinct [Field Name], ';')

This will create a list of possible values while excluding the desired value.