topic expression with alternate states in QlikView https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827791#M999716 <HTML><HEAD></HEAD><BODY><P>I have an expression: count(distinct{GroupC}responses_id)</P><P>This works fine. But I need to have a filter NPS_Flag=1, how do I put it in this expression?</P></BODY></HTML> Tue, 16 Jun 2015 06:45:37 GMT 2015-06-16T06:45:37Z expression with alternate states https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827791#M999716 <HTML><HEAD></HEAD><BODY><P>I have an expression: count(distinct{GroupC}responses_id)</P><P>This works fine. But I need to have a filter NPS_Flag=1, how do I put it in this expression?</P></BODY></HTML> Tue, 16 Jun 2015 06:45:37 GMT https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827791#M999716 2015-06-16T06:45:37Z Re: expression with alternate states https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827792#M999717 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this</P><P><SPAN style="color: #0000ff; font-size: 8pt;">count({&lt;NPS_Flag={1}&gt;}distinct{GroupC}responses_id)</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;"><BR /></SPAN></P><P><SPAN style="font-size: 8pt;"><BR /></SPAN></P></BODY></HTML> Tue, 16 Jun 2015 06:50:41 GMT https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827792#M999717 ankit777 2015-06-16T06:50:41Z Re: expression with alternate states https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827793#M999718 <HTML><HEAD></HEAD><BODY><P> count(distinct{[GroupC]&lt;NPS_Flag={'1'}&gt;}responses_id)</P></BODY></HTML> Tue, 16 Jun 2015 06:55:53 GMT https://community.qlik.com/t5/QlikView/expression-with-alternate-states/m-p/827793#M999718 2015-06-16T06:55:53Z