topic Re: Count in Set Analysis with a Specific Value in QlikView https://community.qlik.com/t5/QlikView/Count-in-Set-Analysis-with-a-Specific-Value/m-p/628460#M1095273 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">= COUNT ({$&lt;ID_TIE_DATE#={"&gt;=$(='$(vDateFrom)')&lt;=$(='$(vDateTo)')"}, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Q_VALUES</SPAN>={6}&gt;} Q_VALUES)</SPAN></P></BODY></HTML> Fri, 09 May 2014 16:09:36 GMT alexandros17 2014-05-09T16:09:36Z Count in Set Analysis with a Specific Value https://community.qlik.com/t5/QlikView/Count-in-Set-Analysis-with-a-Specific-Value/m-p/628459#M1095272 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I have the following expression:</P><P></P><P>= COUNT ({$&lt;ID_TIE_DATE#={"&gt;=$(='$(vDateFrom)')&lt;=$(='$(vDateTo)')"}&gt;} Q_VALUES)</P><P></P><P>Where the field Q_VALUES could have values like: 0 or 6.</P><P></P><P>What I want is to count only those values who have a 6.</P><P></P><P>Do you know how could I do that?</P><P></P><P>Thank you!!!</P></BODY></HTML> Fri, 09 May 2014 16:06:23 GMT https://community.qlik.com/t5/QlikView/Count-in-Set-Analysis-with-a-Specific-Value/m-p/628459#M1095272 microwin88x 2014-05-09T16:06:23Z Re: Count in Set Analysis with a Specific Value https://community.qlik.com/t5/QlikView/Count-in-Set-Analysis-with-a-Specific-Value/m-p/628460#M1095273 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">= COUNT ({$&lt;ID_TIE_DATE#={"&gt;=$(='$(vDateFrom)')&lt;=$(='$(vDateTo)')"}, <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Q_VALUES</SPAN>={6}&gt;} Q_VALUES)</SPAN></P></BODY></HTML> Fri, 09 May 2014 16:09:36 GMT https://community.qlik.com/t5/QlikView/Count-in-Set-Analysis-with-a-Specific-Value/m-p/628460#M1095273 alexandros17 2014-05-09T16:09:36Z