topic Re: Syntax for distinct count using alternate states in QlikView https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784855#M1031126 <HTML><HEAD></HEAD><BODY><P>This worked! Thank you!</P></BODY></HTML> Thu, 29 Jan 2015 17:25:14 GMT 2015-01-29T17:25:14Z Syntax for distinct count using alternate states https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784852#M1031123 <HTML><HEAD></HEAD><BODY><P>I am having a hard time coming up with the correct syntax for this simple calculation...</P><P></P><P>I need to do a distinct count of Seq #'s in Alternate State A and Alternate State B.</P><P>Here is what I've got...</P><P></P><P>=count({StateA} Distinct [Seq#]</P><P></P><P>Simple but it's not affected by the default state filters and I want it to be.</P><P></P><P>What do I need to add to make this formula work with other filters?</P><P></P><P>Thanks in advance:)</P></BODY></HTML> Thu, 29 Jan 2015 02:18:19 GMT https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784852#M1031123 2015-01-29T02:18:19Z Re: Syntax for distinct count using alternate states https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784853#M1031124 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this one:</P><P>=count({$*StateA} distinct [Seq#])</P><P></P><P>Regards,</P><P>Andrei Kaliahin</P></BODY></HTML> Thu, 29 Jan 2015 05:27:47 GMT https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784853#M1031124 crusader_ 2015-01-29T05:27:47Z Re: Syntax for distinct count using alternate states https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784854#M1031125 <HTML><HEAD></HEAD><BODY><P>Check this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">count</SPAN>({[Group1]}DISTINCT <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">[Seq#]</SPAN>)</P></BODY></HTML> Thu, 29 Jan 2015 05:43:14 GMT https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784854#M1031125 sagarkharpude 2015-01-29T05:43:14Z Re: Syntax for distinct count using alternate states https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784855#M1031126 <HTML><HEAD></HEAD><BODY><P>This worked! Thank you!</P></BODY></HTML> Thu, 29 Jan 2015 17:25:14 GMT https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784855#M1031126 2015-01-29T17:25:14Z Re: Syntax for distinct count using alternate states https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784856#M1031127 <HTML><HEAD></HEAD><BODY><P>This didn't work for me. I think you need the $* to listen to all other filters.</P></BODY></HTML> Thu, 29 Jan 2015 17:26:04 GMT https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784856#M1031127 2015-01-29T17:26:04Z Re: Syntax for distinct count using alternate states https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784857#M1031128 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If the issue is resolved, Marked it as correct answer.</P></BODY></HTML> Fri, 30 Jan 2015 03:57:07 GMT https://community.qlik.com/t5/QlikView/Syntax-for-distinct-count-using-alternate-states/m-p/784857#M1031128 sagarkharpude 2015-01-30T03:57:07Z