topic Set Analysis Syntax in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/224857#M77220 <HTML><HEAD></HEAD><BODY><P>This does not work:<BR /><BR />Count({$&lt;RebateAmtReported={"=0"}&gt;} DISTINCT TransactionID)<BR /><BR />But this does:<BR /><BR />Count({$&lt;RebateAmtReported={"&lt;&gt;0"}&gt;} DISTINCT TransactionID)<BR /><BR />Why?<BR /><BR />I'm trying to get a count of transactions w/rebates vs. transactions without rebates.</P></BODY></HTML> Thu, 15 Jul 2010 21:22:56 GMT 2010-07-15T21:22:56Z Set Analysis Syntax https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/224857#M77220 <HTML><HEAD></HEAD><BODY><P>This does not work:<BR /><BR />Count({$&lt;RebateAmtReported={"=0"}&gt;} DISTINCT TransactionID)<BR /><BR />But this does:<BR /><BR />Count({$&lt;RebateAmtReported={"&lt;&gt;0"}&gt;} DISTINCT TransactionID)<BR /><BR />Why?<BR /><BR />I'm trying to get a count of transactions w/rebates vs. transactions without rebates.</P></BODY></HTML> Thu, 15 Jul 2010 21:22:56 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/224857#M77220 2010-07-15T21:22:56Z Set Analysis Syntax https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/224858#M77221 <HTML><HEAD></HEAD><BODY><P>This should work:</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Count({$&lt;RebateAmtReported={"0"}&gt;} DISTINCT TransactionID)</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Fri, 16 Jul 2010 01:48:43 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/224858#M77221 2010-07-16T01:48:43Z