topic Can I do this with SET analys? in QlikView https://community.qlik.com/t5/QlikView/Can-I-do-this-with-SET-analys/m-p/349824#M1176144 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have YearMonth, StartDate and EndDate. What I want is to count a field with ID that have StartDate up to the month selected and Enddate = Today(). </P><P>The second picture in the middel desribe what I want and the first what I now get when I select the YearMonth field. (But the EndDate are manually marked at both picts, will just use Today() as expression in the set)&nbsp; </P><P>I tried this =Count({$&lt;StartDate={"&gt;0"},EndDate={'$(=Today())'}&gt;}INSATSID)&nbsp; but I need it to cut after the month selected so it dont count StartDate in ex 2012 in this example. </P><P><IMG alt="QV Set.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12094_QV+Set.JPG" width="450" /> </P></BODY></HTML> Tue, 13 Mar 2012 10:18:35 GMT 2012-03-13T10:18:35Z Can I do this with SET analys? https://community.qlik.com/t5/QlikView/Can-I-do-this-with-SET-analys/m-p/349824#M1176144 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have YearMonth, StartDate and EndDate. What I want is to count a field with ID that have StartDate up to the month selected and Enddate = Today(). </P><P>The second picture in the middel desribe what I want and the first what I now get when I select the YearMonth field. (But the EndDate are manually marked at both picts, will just use Today() as expression in the set)&nbsp; </P><P>I tried this =Count({$&lt;StartDate={"&gt;0"},EndDate={'$(=Today())'}&gt;}INSATSID)&nbsp; but I need it to cut after the month selected so it dont count StartDate in ex 2012 in this example. </P><P><IMG alt="QV Set.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12094_QV+Set.JPG" width="450" /> </P></BODY></HTML> Tue, 13 Mar 2012 10:18:35 GMT https://community.qlik.com/t5/QlikView/Can-I-do-this-with-SET-analys/m-p/349824#M1176144 2012-03-13T10:18:35Z Can I do this with SET analys? https://community.qlik.com/t5/QlikView/Can-I-do-this-with-SET-analys/m-p/349825#M1176145 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><P>=Count({$&lt;StartDate={"&lt;$(=monthend(makedate(left(YEARMONTH,4),right(YEARMONTH,2)))"},EndDate={'$(=Today())'}&gt;}INSATSID)</P><P></P><P>makedate(..) could be replaced by YEARMONTH, if YEARMONTH is of type date.</P></BODY></HTML> Tue, 13 Mar 2012 10:25:02 GMT https://community.qlik.com/t5/QlikView/Can-I-do-this-with-SET-analys/m-p/349825#M1176145 swuehl 2012-03-13T10:25:02Z