topic Exclusion Of Table Data Based On A Flag in QlikView https://community.qlik.com/t5/QlikView/Exclusion-Of-Table-Data-Based-On-A-Flag/m-p/1392791#M423236 <HTML><HEAD></HEAD><BODY><P>Hi all. I have a situation where I need to exclude information from a query based on a set flag. I would like to use a case statement as shown below in my sql code and not rely on expressions. </P><P></P><P>CASE WHEN PN.SWPARTNUMBER &lt;&gt; A.ATNETWORKPARTNUMBER and (A.ATPARTNUMBERDISCREPANCYVALID = '1') Then 1 else 0 END as DR02_Part_Number_Validated</P><P></P><P>I have a join setup between the two tables. The field that contains the flag set to 1 is the ATPARTNUMBERDISCREPANCYVALID field. If this is true or "1" than the SWPARTNUMBER AND ATNETWORKPARTNUMBER essentially match and therefore should not be included in the table data on the sheet that pulls this information.</P><P></P><P>Any ideas are greatly appreciated. </P></BODY></HTML> Wed, 18 Oct 2017 16:49:44 GMT pandreozzi 2017-10-18T16:49:44Z Exclusion Of Table Data Based On A Flag https://community.qlik.com/t5/QlikView/Exclusion-Of-Table-Data-Based-On-A-Flag/m-p/1392791#M423236 <HTML><HEAD></HEAD><BODY><P>Hi all. I have a situation where I need to exclude information from a query based on a set flag. I would like to use a case statement as shown below in my sql code and not rely on expressions. </P><P></P><P>CASE WHEN PN.SWPARTNUMBER &lt;&gt; A.ATNETWORKPARTNUMBER and (A.ATPARTNUMBERDISCREPANCYVALID = '1') Then 1 else 0 END as DR02_Part_Number_Validated</P><P></P><P>I have a join setup between the two tables. The field that contains the flag set to 1 is the ATPARTNUMBERDISCREPANCYVALID field. If this is true or "1" than the SWPARTNUMBER AND ATNETWORKPARTNUMBER essentially match and therefore should not be included in the table data on the sheet that pulls this information.</P><P></P><P>Any ideas are greatly appreciated. </P></BODY></HTML> Wed, 18 Oct 2017 16:49:44 GMT https://community.qlik.com/t5/QlikView/Exclusion-Of-Table-Data-Based-On-A-Flag/m-p/1392791#M423236 pandreozzi 2017-10-18T16:49:44Z