topic Exclude values from filter in QlikView

Exclude values from filter

Anonymous — Sun, 25 Oct 2015 10:22:00 GMT

I have code site filter . How can I exclude 101 ,102,103,104 and 105 from selection ? how can I make 101 ,102,103,104 and 105 in grey color ?

Re: Exclude values from filter

marcus_sommer — Sun, 25 Oct 2015 10:29:50 GMT

I'm not sure if it's possible to make those values in general grey and unselectable but you could they exclude completely by using from an listbox-expression like this:

if(not match([Code Site], 101,102,103,104,105), [Code Site])

- Marcus

Re: Exclude values from filter

HirisH_V7 — Sun, 25 Oct 2015 10:38:28 GMT

Hi,

You can write in Script like this ,

Where CodeSite <>( '101','102','103')

Like this

Re: Exclude values from filter

Sun, 25 Oct 2015 10:39:51 GMT

if they appear in grey color that is mean they are not associated with the current selection like site code 2000.