topic Conditional COUNT in an expression in QlikView https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339384#M125218 <HTML><HEAD></HEAD><BODY><P>I assume you want to use that expression in the front end, right? </P><P></P><P>Try in a chart object this as expression:</P><P></P><P>=count(distinct if( X &lt;= 8, Y) )</P></BODY></HTML> Tue, 06 Mar 2012 22:49:38 GMT swuehl 2012-03-06T22:49:38Z Conditional COUNT in an expression https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339383#M125217 <HTML><HEAD></HEAD><BODY><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">I need a variable with a value that comes from a counter that requires a simple condition. Please help me to create this expression.</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">The condition is if a specific table field (X) is&nbsp; &lt;= 8. If yes, the expression most count distinct an other field&nbsp; (Y).</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">In SQL it will be like</P><P></P><P style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select COUNT(Y) from TABLE where X &lt;=8</P></BODY></HTML> Tue, 06 Mar 2012 22:32:51 GMT https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339383#M125217 Anonymous 2012-03-06T22:32:51Z Conditional COUNT in an expression https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339384#M125218 <HTML><HEAD></HEAD><BODY><P>I assume you want to use that expression in the front end, right? </P><P></P><P>Try in a chart object this as expression:</P><P></P><P>=count(distinct if( X &lt;= 8, Y) )</P></BODY></HTML> Tue, 06 Mar 2012 22:49:38 GMT https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339384#M125218 swuehl 2012-03-06T22:49:38Z Conditional COUNT in an expression https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339385#M125219 <HTML><HEAD></HEAD><BODY><P>Worked well. Thanks !</P></BODY></HTML> Tue, 06 Mar 2012 22:52:35 GMT https://community.qlik.com/t5/QlikView/Conditional-COUNT-in-an-expression/m-p/339385#M125219 Anonymous 2012-03-06T22:52:35Z