https://community.qlik.com/t5/App-Development/Set-Analysis-syntaxes-examples/m-p/1586701#M42928 <P>Please correct me the below expression&nbsp; for the&nbsp; Qlik Sense KPI.&nbsp;</P><P>&nbsp;</P><P>1. Count({&lt;STATUS -={'REJECTED'}, TYPE ={'RTP'} ,TYPE = &nbsp;{'ITP'}&gt;}&nbsp; TextValue)</P><P>2.&nbsp;&nbsp;Count({&lt;STATUS -={'REJECTED'}, TYPE ={'RTP'&nbsp; &nbsp;,&nbsp; &nbsp; 'ITP'}&gt;}&nbsp; TextValue)</P><P>&nbsp;</P><P>I'm getting two different results for the above expression. please correct me which one is accurate</P><P>&nbsp;</P><P>Column 'TYPE. = RTP, ITP, DPI, FTP</P> Sat, 16 Nov 2024 05:42:06 GMT datashaw 2024-11-16T05:42:06Z https://community.qlik.com/t5/App-Development/Set-Analysis-syntaxes-examples/m-p/1586701#M42928 <P>Please correct me the below expression&nbsp; for the&nbsp; Qlik Sense KPI.&nbsp;</P><P>&nbsp;</P><P>1. Count({&lt;STATUS -={'REJECTED'}, TYPE ={'RTP'} ,TYPE = &nbsp;{'ITP'}&gt;}&nbsp; TextValue)</P><P>2.&nbsp;&nbsp;Count({&lt;STATUS -={'REJECTED'}, TYPE ={'RTP'&nbsp; &nbsp;,&nbsp; &nbsp; 'ITP'}&gt;}&nbsp; TextValue)</P><P>&nbsp;</P><P>I'm getting two different results for the above expression. please correct me which one is accurate</P><P>&nbsp;</P><P>Column 'TYPE. = RTP, ITP, DPI, FTP</P> Sat, 16 Nov 2024 05:42:06 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-syntaxes-examples/m-p/1586701#M42928 datashaw 2024-11-16T05:42:06Z https://community.qlik.com/t5/App-Development/Set-Analysis-syntaxes-examples/m-p/1586750#M42935 <P>In #1, you are requiring TYPE to be equal to RTP <STRONG><U>and</U></STRONG> ITP, which is (probably) impossible for any given row. In #2, you are requiring TYPE to be equal to RTP <U><STRONG>or</STRONG></U> ITP.</P> Thu, 30 May 2019 15:54:13 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-syntaxes-examples/m-p/1586750#M42935 Lauri 2019-05-30T15:54:13Z