topic Count on condition in QlikView https://community.qlik.com/t5/QlikView/Count-on-condition/m-p/232445#M84058 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>suppose I have a data structure in QV as this one :</P><P>- Customer Number<BR />- Date<BR />- Value</P><P>If I want to show on a linear table (or a pivot one), with Date as the dimension, only the count of customer (for each day) that have a value greather than 5 what I have to do ?</P><P>Thanks a lot.</P><P>Bye</P></BODY></HTML> Wed, 05 May 2010 16:14:23 GMT 2010-05-05T16:14:23Z Count on condition https://community.qlik.com/t5/QlikView/Count-on-condition/m-p/232445#M84058 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>suppose I have a data structure in QV as this one :</P><P>- Customer Number<BR />- Date<BR />- Value</P><P>If I want to show on a linear table (or a pivot one), with Date as the dimension, only the count of customer (for each day) that have a value greather than 5 what I have to do ?</P><P>Thanks a lot.</P><P>Bye</P></BODY></HTML> Wed, 05 May 2010 16:14:23 GMT https://community.qlik.com/t5/QlikView/Count-on-condition/m-p/232445#M84058 2010-05-05T16:14:23Z Count on condition https://community.qlik.com/t5/QlikView/Count-on-condition/m-p/232446#M84059 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P style="padding-left:30px;">count(distinct if(Value&gt;5,"Customer Number"))</P></BODY></HTML> Wed, 05 May 2010 20:05:08 GMT https://community.qlik.com/t5/QlikView/Count-on-condition/m-p/232446#M84059 johnw 2010-05-05T20:05:08Z