Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to filter my region in my pivot table?

Hello,

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?

Capture.PNG

thanks

Bhavesh

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: How to filter my region in my pivot table?

In Chart Properties|Dimensions, check Suppress when NULL

View solution in original post

3 Replies
Highlighted
Master II
Master II

Re: How to filter my region in my pivot table?

In Chart Properties|Dimensions, check Suppress when NULL

View solution in original post

Highlighted
Creator
Creator

Re: How to filter my region in my pivot table?

^

Highlighted
Creator III
Creator III

Re: How to filter my region in my pivot table?

thank you, it worked for me