topic Re: How to filter my region in my pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115828#M758545 <HTML><HEAD></HEAD><BODY><P>thank you, it worked for me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 23 Aug 2018 14:53:27 GMT bhaveshp90 2018-08-23T14:53:27Z How to filter my region in my pivot table? https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115825#M758542 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P></P><P>How can I filter the region to show only 'NA' and 'EU' in my pivot table excluding 'China' and 'ASEAN'?</P><P></P><P>I'm using the following condition as of now?</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = if(not WildMatch(Region,'China','ANZ-ASEAN'), Region)</P><P></P><P>It is filtering but I am getting a new value '-' in my region as shown below.&nbsp; How to get rid of this? </P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" height="338" src="https://community.qlik.com/legacyfs/online/211630_Capture.PNG" style="height: 338px; width: 416.241px;" width="416" /></P><P></P><P>thanks</P><P>Bhavesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115825#M758542 bhaveshp90 2020-11-25T16:16:04Z Re: How to filter my region in my pivot table? https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115826#M758543 <HTML><HEAD></HEAD><BODY><P>In Chart Properties|Dimensions, check Suppress when NULL</P></BODY></HTML> Thu, 23 Aug 2018 14:37:16 GMT https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115826#M758543 m_woolf 2018-08-23T14:37:16Z Re: How to filter my region in my pivot table? https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115827#M758544 <HTML><HEAD></HEAD><BODY><P>^</P></BODY></HTML> Thu, 23 Aug 2018 14:40:22 GMT https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115827#M758544 groveliam 2018-08-23T14:40:22Z Re: How to filter my region in my pivot table? https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115828#M758545 <HTML><HEAD></HEAD><BODY><P>thank you, it worked for me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 23 Aug 2018 14:53:27 GMT https://community.qlik.com/t5/QlikView/How-to-filter-my-region-in-my-pivot-table/m-p/115828#M758545 bhaveshp90 2018-08-23T14:53:27Z