topic Re: issue in IF statement in expr in Archived Groups https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53484#M1079 <HTML><HEAD></HEAD><BODY><P>May be try this instead</P><P></P><P><STRONG>Num(Count({&lt;ORDER_STAT = {'11', '12'}&gt;} DISTINCT ORDER_NUM))</STRONG></P></BODY></HTML> Wed, 18 Apr 2018 09:07:59 GMT sunny_talwar 2018-04-18T09:07:59Z issue in IF statement in expr https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53483#M1078 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>This is my if statement condition--&gt; <SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">If</SPAN><SPAN style="font-size: 8pt;">((</SPAN><SPAN style="color: #800000; font-size: 8pt;">ORDER_STAT</SPAN><SPAN style="font-size: 8pt;">=11 </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">OR</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">ORDER_STAT</SPAN><SPAN style="font-size: 8pt;">=12),</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ORDER_NUM</SPAN><SPAN style="font-size: 8pt;">)))) </SPAN></P><P></P><P>The expression has no errors. but my chart is not showing anything. Only this part is working: <SPAN style="color: #0000ff; font-size: 8pt;">Num</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ORDER_NUM</SPAN><SPAN style="font-size: 8pt;">)))</SPAN></P><P></P><P></P><P>Could anyone help me identify what is that I am missing?</P><P></P><P>Thank you!</P><P>Regards,</P><P>Sai</P></BODY></HTML> Tue, 22 Jul 2025 17:59:49 GMT https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53483#M1078 Qlik_Enthu 2025-07-22T17:59:49Z Re: issue in IF statement in expr https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53484#M1079 <HTML><HEAD></HEAD><BODY><P>May be try this instead</P><P></P><P><STRONG>Num(Count({&lt;ORDER_STAT = {'11', '12'}&gt;} DISTINCT ORDER_NUM))</STRONG></P></BODY></HTML> Wed, 18 Apr 2018 09:07:59 GMT https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53484#M1079 sunny_talwar 2018-04-18T09:07:59Z Re: issue in IF statement in expr https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53485#M1080 <HTML><HEAD></HEAD><BODY><P>Hi thanks much it worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 18 Apr 2018 12:31:19 GMT https://community.qlik.com/t5/Archived-Groups/issue-in-IF-statement-in-expr/m-p/53485#M1080 Qlik_Enthu 2018-04-18T12:31:19Z