topic Re: How i get the first 6 months in QlikView https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983026#M949547 <HTML><HEAD></HEAD><BODY><P>What do you mean by 1st 6 months? You mean the latest 6 months?</P></BODY></HTML> Wed, 09 Dec 2015 19:08:22 GMT sunny_talwar 2015-12-09T19:08:22Z How i get the first 6 months https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983025#M949546 <HTML><HEAD></HEAD><BODY><P>Hi guys.</P><P></P><P>Need a hand here. I need to calculate the payments but only the first six months.</P><P></P><P>the problem is that I do not have the month as a dimension, I have the date in format YYYYMMDD.</P><P></P><P>I dont know how to elaborate a set analysis that give just the first semester (six first months)</P><P></P><P>Can anyone help me?</P><P><IMG alt="12.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/108497_12.PNG" style="height: 239px; width: 620px;" /></P></BODY></HTML> Wed, 09 Dec 2015 16:08:33 GMT https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983025#M949546 slondono 2015-12-09T16:08:33Z Re: How i get the first 6 months https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983026#M949547 <HTML><HEAD></HEAD><BODY><P>What do you mean by 1st 6 months? You mean the latest 6 months?</P></BODY></HTML> Wed, 09 Dec 2015 19:08:22 GMT https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983026#M949547 sunny_talwar 2015-12-09T19:08:22Z Re: How i get the first 6 months https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983027#M949548 <HTML><HEAD></HEAD><BODY><P><EM>=sum( {$&lt;[Date YYYYMMDD]={"&gt;=$(=date(makedate(max(YEAR)),'YYYYMMDD')) </EM></P><P><EM>&lt;=$(=date(MonthEnd(makedate(max(YEAR),6)),'YYYYMMDD'))"}&gt;} yourfield )</EM></P></BODY></HTML> Wed, 09 Dec 2015 19:45:15 GMT https://community.qlik.com/t5/QlikView/How-i-get-the-first-6-months/m-p/983027#M949548 maxgro 2015-12-09T19:45:15Z