topic Help in expression in QlikView https://community.qlik.com/t5/QlikView/Help-in-expression/m-p/401227#M485664 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>My data looks like this. The requirement is to count the customers that are deactivated (having status as "D"). In the example below - my count of deactivated customers&nbsp; should return 1 - i.e. CustC. Because only for that customer the status is D for all dates. Can this be done as an expression?</P><P><IMG __jive_id="39712" class="jive-image" alt="QV_Data.png" src="https://community.qlik.com/legacyfs/online/39712_QV_Data.png" /></P><P></P><P>Thanks,</P><P>Abey</P></BODY></HTML> Thu, 25 Apr 2013 17:26:44 GMT abeyphilip 2013-04-25T17:26:44Z Help in expression https://community.qlik.com/t5/QlikView/Help-in-expression/m-p/401227#M485664 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>My data looks like this. The requirement is to count the customers that are deactivated (having status as "D"). In the example below - my count of deactivated customers&nbsp; should return 1 - i.e. CustC. Because only for that customer the status is D for all dates. Can this be done as an expression?</P><P><IMG __jive_id="39712" class="jive-image" alt="QV_Data.png" src="https://community.qlik.com/legacyfs/online/39712_QV_Data.png" /></P><P></P><P>Thanks,</P><P>Abey</P></BODY></HTML> Thu, 25 Apr 2013 17:26:44 GMT https://community.qlik.com/t5/QlikView/Help-in-expression/m-p/401227#M485664 abeyphilip 2013-04-25T17:26:44Z Re: Help in expression https://community.qlik.com/t5/QlikView/Help-in-expression/m-p/401228#M485665 <HTML><HEAD></HEAD><BODY><P>Try: count({&lt;Cust= e({&lt;Status-={'D'}&gt;} Cust) &gt;} distinct Cust)</P></BODY></HTML> Thu, 25 Apr 2013 18:27:27 GMT https://community.qlik.com/t5/QlikView/Help-in-expression/m-p/401228#M485665 Gysbert_Wassenaar 2013-04-25T18:27:27Z