topic proper syntax for distinct count in QlikView https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792297#M1033939 <HTML><HEAD></HEAD><BODY><P>I need to do a distinct count of Rx# when Refill# = 0. Here's my expression so far...</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[RX#]</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">P</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Refill#]</SPAN><SPAN style="font-size: 8pt;">={0}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[RX#]</SPAN><SPAN style="font-size: 8pt;">)&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[RX#]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>How do you tweak this to include a distinct count of RX#?</P><P></P><P>I'm failing at figuring this one out.</P><P></P><P>Thank you.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 14 Jan 2015 18:58:03 GMT 2015-01-14T18:58:03Z proper syntax for distinct count https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792297#M1033939 <HTML><HEAD></HEAD><BODY><P>I need to do a distinct count of Rx# when Refill# = 0. Here's my expression so far...</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">Count</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[RX#]</SPAN><SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">P</SPAN><SPAN style="font-size: 8pt;">({1&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Refill#]</SPAN><SPAN style="font-size: 8pt;">={0}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[RX#]</SPAN><SPAN style="font-size: 8pt;">)&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[RX#]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P>How do you tweak this to include a distinct count of RX#?</P><P></P><P>I'm failing at figuring this one out.</P><P></P><P>Thank you.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P></BODY></HTML> Wed, 14 Jan 2015 18:58:03 GMT https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792297#M1033939 2015-01-14T18:58:03Z Re: proper syntax for distinct count https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792298#M1033940 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>Count(Distinct {$&lt;[Refil#]={0}&gt;}[RX#])</P></BODY></HTML> Wed, 14 Jan 2015 19:01:42 GMT https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792298#M1033940 vinafidalgo 2015-01-14T19:01:42Z Re: proper syntax for distinct count https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792299#M1033941 <HTML><HEAD></HEAD><BODY><P>DISTINCT clause must precede you Set Analysis expression</P></BODY></HTML> Wed, 14 Jan 2015 19:08:20 GMT https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792299#M1033941 Clever_Anjos 2015-01-14T19:08:20Z Re: proper syntax for distinct count https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792300#M1033942 <HTML><HEAD></HEAD><BODY><P>Thank you Vinivius! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 15 Jan 2015 22:22:39 GMT https://community.qlik.com/t5/QlikView/proper-syntax-for-distinct-count/m-p/792300#M1033942 2015-01-15T22:22:39Z