topic Re: Remove rows using Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115639#M901486 <HTML><HEAD></HEAD><BODY><P>This works. I checked Supress Null Values/Missing Values to exclude blank cells. Thanks!</P></BODY></HTML> Thu, 21 Jul 2016 10:36:47 GMT 2016-07-21T10:36:47Z Remove rows using Calculated Dimension https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115637#M901482 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Could you please help me on how to remove rows in this (below) Pivot Table using a Calculated Dimension?</P><P></P><P><IMG alt="1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132038_1.PNG" style="height: auto;" /></P><P></P><P>I want to remove <STRONG>GMM East</STRONG> and <STRONG>GMM West</STRONG> in <STRONG>Section 1</STRONG>, vice versa in <STRONG>Section 2</STRONG>, so the output will be like this (below) table:</P><P></P><P><IMG alt="2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/132039_2.PNG" style="height: auto;" /></P><P></P><P><STRONG>GMMAREA</STRONG> is a data column from table file, while <STRONG>GMM1</STRONG> and <STRONG>GMM</STRONG> are Inline loaded table. Attached is my script in .txt format.</P><P></P><P>Thank you!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115637#M901482 2020-11-25T16:16:04Z Re: Remove rows using Calculated Dimension https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115638#M901484 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P>Replace <STRONG>GMMAREA</STRONG> with this:</P><P><STRONG>If(GMM = 'Section 1', If(WildMatch(GMMAREA, '*South', '*North'), <SPAN style="font-size: 13.3333px;">GMMAREA),</SPAN></STRONG></P><P><SPAN style="font-size: 13.3333px;"><STRONG>If(<SPAN style="font-size: 13.3333px;">GMM = 'Section 2', If(WildMatch(GMMAREA, '*East', '*West'), </SPAN></STRONG><SPAN style="font-size: 13.3333px;"><STRONG>GMMAREA)))</STRONG></SPAN></SPAN></P></BODY></HTML> Thu, 21 Jul 2016 10:21:37 GMT https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115638#M901484 sunny_talwar 2016-07-21T10:21:37Z Re: Remove rows using Calculated Dimension https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115639#M901486 <HTML><HEAD></HEAD><BODY><P>This works. I checked Supress Null Values/Missing Values to exclude blank cells. Thanks!</P></BODY></HTML> Thu, 21 Jul 2016 10:36:47 GMT https://community.qlik.com/t5/QlikView/Remove-rows-using-Calculated-Dimension/m-p/1115639#M901486 2016-07-21T10:36:47Z