topic Re: Conditional Counting in QlikView https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762127#M1042578 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">=COUNT({&lt;Cost = {"&gt;0"}&gt;}DISTINCT Group)</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">or</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">=Count({&lt;Group = {"=SUM(Cost)&gt;0"}&gt;}DISTINCT Group)</P></BODY></HTML> Tue, 02 Dec 2014 23:44:33 GMT MK_QSL 2014-12-02T23:44:33Z Conditional Counting https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762125#M1042576 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a question (probably super simple for most of you)...</P><P></P><P>I need to create an expression where I am able to distinctly count records in column 1 if the records in column 2 are greater than zero. Here's an example that has no particular relevance:</P><P></P><P>Group&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cost</P><P>A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $1.21</P><P>B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $3.16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.92</P><P>D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.00</P><P>E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $10.22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.00</P><P></P><P>The answer would be 4 because I would count A, B, C, and E since they are all greater than $0.00.</P><P></P><P>How do I do this?</P><P></P><P>Thanks in advance:)</P></BODY></HTML> Tue, 02 Dec 2014 20:26:51 GMT https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762125#M1042576 2014-12-02T20:26:51Z Re: Conditional Counting https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762126#M1042577 <HTML><HEAD></HEAD><BODY><P>Try something like:</P><P></P><P>Count({&lt;Cost = {"&gt;0"}&gt;} Distinct Group)</P><P></P><P>mike</P></BODY></HTML> Tue, 02 Dec 2014 20:32:38 GMT https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762126#M1042577 mikecrengland 2014-12-02T20:32:38Z Re: Conditional Counting https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762127#M1042578 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">=COUNT({&lt;Cost = {"&gt;0"}&gt;}DISTINCT Group)</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">or</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">=Count({&lt;Group = {"=SUM(Cost)&gt;0"}&gt;}DISTINCT Group)</P></BODY></HTML> Tue, 02 Dec 2014 23:44:33 GMT https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762127#M1042578 MK_QSL 2014-12-02T23:44:33Z Re: Conditional Counting https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762128#M1042579 <HTML><HEAD></HEAD><BODY><P>Thank you Mike!</P></BODY></HTML> Wed, 03 Dec 2014 02:40:15 GMT https://community.qlik.com/t5/QlikView/Conditional-Counting/m-p/762128#M1042579 2014-12-03T02:40:15Z