topic Exprsn in QlikView https://community.qlik.com/t5/QlikView/Exprsn/m-p/1383707#M806015 <HTML><HEAD></HEAD><BODY><P>HI Expertise </P><P>Please find the attachment of the QVW file.</P><P>currently i have the created date till OCTOBER 2017.</P><P></P><P></P><P>I want to show the 24 months back from max created date ...</P><P></P><P></P><P>But right now it is showing 2 years back ..</P><P></P><P></P><P>Actaully it whould from OCT-2017 back to 24 month-year..</P><P>What changes needs to be done to the dimesion ?</P><P></P><P></P><P>Thanks in advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT smilingjohn 2020-11-25T16:16:04Z Exprsn https://community.qlik.com/t5/QlikView/Exprsn/m-p/1383707#M806015 <HTML><HEAD></HEAD><BODY><P>HI Expertise </P><P>Please find the attachment of the QVW file.</P><P>currently i have the created date till OCTOBER 2017.</P><P></P><P></P><P>I want to show the 24 months back from max created date ...</P><P></P><P></P><P>But right now it is showing 2 years back ..</P><P></P><P></P><P>Actaully it whould from OCT-2017 back to 24 month-year..</P><P>What changes needs to be done to the dimesion ?</P><P></P><P></P><P>Thanks in advance </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exprsn/m-p/1383707#M806015 smilingjohn 2020-11-25T16:16:04Z Re: Exprsn https://community.qlik.com/t5/QlikView/Exprsn/m-p/1383708#M806016 <HTML><HEAD></HEAD><BODY><P>Try this</P><P></P><P>Dimension</P><P><STRONG>MonthName(Created)</STRONG></P><P></P><P>Expression</P><P><STRONG>Count({&lt;Created = {"$(='&gt;=' &amp; TimeStamp(MonthStart(Max(Created), -24), 'DD-MM-YYYY hh:mm:ss') &amp; '&lt;' &amp; TimeStamp(MonthStart(Max(Created), 1), 'DD-MM-YYYY hh:mm:ss'))"}&gt;}Key)</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181607_Capture.PNG" style="height: 146px; width: 620px;" /></P></BODY></HTML> Tue, 31 Oct 2017 12:04:45 GMT https://community.qlik.com/t5/QlikView/Exprsn/m-p/1383708#M806016 sunny_talwar 2017-10-31T12:04:45Z