Discussion board where members can get started with QlikView.
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 ?
Go to Solution.
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])
View solution in original post
You can write in Script like this ,
Where CodeSite <>( '101','102','103')
if they appear in grey color that is mean they are not associated with the current selection like site code 2000.