Discussion board where members can get started with QlikView.
How can I filter the region to show only 'NA' and 'EU' in my pivot table excluding 'China' and 'ASEAN'?
I'm using the following condition as of now?
= if(not WildMatch(Region,'China','ANZ-ASEAN'), Region)
It is filtering but I am getting a new value '-' in my region as shown below. How to get rid of this?
In Chart Properties|Dimensions, check Suppress when NULL
View solution in original post
thank you, it worked for me