Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jaweher89
New Contributor III

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
MVP & Luminary
MVP & Luminary

Re: Exclude values from filter

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
MVP & Luminary
MVP & Luminary

Re: Exclude values from filter

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

HirisH_V7
Honored Contributor

Re: Exclude values from filter

Hi,

You can write in Script like this ,

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

Like this

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

Re: Exclude values from filter

Hi

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