topic Re: Count For user selected value? in QlikView https://community.qlik.com/t5/QlikView/Count-For-user-selected-value/m-p/423202#M1271970 <HTML><HEAD></HEAD><BODY><P>Hey, </P><P>Should your distinct clause must not be just before set analysis ?&nbsp; --&gt;&nbsp;&nbsp; Count(Distinct {&lt;....&gt;}Activity Week) </P></BODY></HTML> Thu, 04 Apr 2013 15:08:55 GMT 2013-04-04T15:08:55Z Count For user selected value? https://community.qlik.com/t5/QlikView/Count-For-user-selected-value/m-p/423201#M1271969 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>Hi,</P><P>Below is the code written for counting based on the selection of ActivityType.</P><P><SPAN style="font-size: 8pt;">Is it right or wrong?</SPAN></P><P></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;">ActivityYear</SPAN><SPAN style="font-size: 8pt;"> = {2013},<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">ActivityMonth</SPAN><SPAN style="font-size: 8pt;">,<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">DueDate</SPAN><SPAN style="font-size: 8pt;">={</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&lt;=$(=Today())&gt;"</SPAN><SPAN style="font-size: 8pt;">},<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">ActivityType</SPAN><SPAN style="font-size: 8pt;">={'$(#vActivityType)'},<BR /></SPAN><SPAN style="color: #800000; font-size: 8pt;">ActivityWeek</SPAN><SPAN style="font-size: 8pt;">&gt;} </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">distinct</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Count</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">)<BR /></SPAN></P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Count-For-user-selected-value/m-p/423201#M1271969 2026-01-26T18:19:17Z Re: Count For user selected value? https://community.qlik.com/t5/QlikView/Count-For-user-selected-value/m-p/423202#M1271970 <HTML><HEAD></HEAD><BODY><P>Hey, </P><P>Should your distinct clause must not be just before set analysis ?&nbsp; --&gt;&nbsp;&nbsp; Count(Distinct {&lt;....&gt;}Activity Week) </P></BODY></HTML> Thu, 04 Apr 2013 15:08:55 GMT https://community.qlik.com/t5/QlikView/Count-For-user-selected-value/m-p/423202#M1271970 2013-04-04T15:08:55Z