Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exclude values from filter

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 ?

2.png

1 Solution

Accepted Solutions
marcus_sommer

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

View solution in original post

3 Replies
marcus_sommer

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

HirisH_V7
Master
Master

Hi,

You can write in Script like this ,

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

Like this

HirisH
“Aspire to Inspire before we Expire!”
Not applicable
Author

Hi

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