topic Re: AddMonth Date in QlikView https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164943#M379352 <HTML><HEAD></HEAD><BODY><P>What about:</P><P>=Count(DISTINCT If(DATE &lt;= AddMonths(Today(),-vDate),STORE_ID))</P></BODY></HTML> Sat, 28 May 2016 15:45:44 GMT swuehl 2016-05-28T15:45:44Z AddMonth Date https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164942#M379351 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to calculate the number of store where the date is up to 4 months.</P><P>Identify the store with the date &gt;= to&nbsp; 4 months.</P><P></P><P>example : the store 4171152 with the date 24/12/2015 is the date up to 4 months.</P><P></P><P>Thank for your help.</P></BODY></HTML> Sat, 28 May 2016 15:33:48 GMT https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164942#M379351 suzel404 2016-05-28T15:33:48Z Re: AddMonth Date https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164943#M379352 <HTML><HEAD></HEAD><BODY><P>What about:</P><P>=Count(DISTINCT If(DATE &lt;= AddMonths(Today(),-vDate),STORE_ID))</P></BODY></HTML> Sat, 28 May 2016 15:45:44 GMT https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164943#M379352 swuehl 2016-05-28T15:45:44Z Re: AddMonth Date https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164944#M379353 <HTML><HEAD></HEAD><BODY><P>Thank you swuehl.</P><P>I ittle modify the calculation to Count(DISTINCT {&lt;DATE={"&lt;=$(=AddMonths(Today(),-vDate))"}&gt;}STORE_ID)</P></BODY></HTML> Sat, 28 May 2016 16:02:25 GMT https://community.qlik.com/t5/QlikView/AddMonth-Date/m-p/1164944#M379353 suzel404 2016-05-28T16:02:25Z