topic Skipping 1 selected filter for COUNT() in QlikView https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560303#M209147 <HTML><HEAD></HEAD><BODY><P>I have Portfolios and Positions. Each Portfolio has many positions for some date.</P><P>I have daterange selection but I vould like to calculate the count of positions for selected Portfolio without taking into account date range selected.</P><P>How can I do that?</P></BODY></HTML> Fri, 01 Nov 2013 15:53:27 GMT 2013-11-01T15:53:27Z Skipping 1 selected filter for COUNT() https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560303#M209147 <HTML><HEAD></HEAD><BODY><P>I have Portfolios and Positions. Each Portfolio has many positions for some date.</P><P>I have daterange selection but I vould like to calculate the count of positions for selected Portfolio without taking into account date range selected.</P><P>How can I do that?</P></BODY></HTML> Fri, 01 Nov 2013 15:53:27 GMT https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560303#M209147 2013-11-01T15:53:27Z Re: Skipping 1 selected filter for COUNT() https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560304#M209148 <HTML><HEAD></HEAD><BODY><P>Please post a Qlikview file with (sample) data.</P></BODY></HTML> Fri, 01 Nov 2013 16:26:43 GMT https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560304#M209148 fred_s 2013-11-01T16:26:43Z Re: Skipping 1 selected filter for COUNT() https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560305#M209149 <HTML><HEAD></HEAD><BODY><P>If you now have an expression like <EM>count(Positions)</EM>, then you can make it ignore selection in a field by adding a set modifier. If your data field is named MyDate it would look like <EM>count({&lt;MyDate=&gt;} Positions)</EM>.</P><P>For more information about set analysis see <A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/download/364323-65849/QlikLearn-Set-Analysis-Presentation.pdf">this document</A>.</P></BODY></HTML> Fri, 01 Nov 2013 17:22:33 GMT https://community.qlik.com/t5/QlikView/Skipping-1-selected-filter-for-COUNT/m-p/560305#M209149 Gysbert_Wassenaar 2013-11-01T17:22:33Z