Try an If Statement in the expression instead...
I have a tab for example where i only want to see data involved with Canada, so in my listbox of countries, i created an if statement within the expression field which now only shows Canada.
=if([Country Name] ='Canada', [Country Name])
you can add as many fields as you need with 'or' and 'and' functions.
hope this helps.
i think that is what you are asking
that being said, this is how i would write an expression to show 2 or more values instead of just 1:
=if([Country Name] ='Canada', or [Country Name]='USA' or [Country Name]='South America', [Country Name])
then all 3 of those countries would show up in my list box and if i just wanted to see USA, i would just click it and my data would drill down to only show USA.
Hope this helps!
Thanks for getting back to me. I didn't envision implementing it as you have described, but essentially, that's what I am looking to do. Once I have developed the functionality in a list box, my goal is to move this to the script where it checks to see if these fields are present or not, and removes them where appropriate.
So essentially, you could do the exact same thing in the script - depending on which data source houses A, B and C, you could write something like this in the script: When you use a 'Where Statement' in the script, you can filter the data during the load instead of having QlikView do this in the design view.
MATERIAL_NUMBER as MATERIAL,
MaterialDesc as DESCRIPTION,
Brand as BRAND
Where Brand = 'A' or Brand = 'B' or Brand = 'C';