topic Re: Can any one help to do this expression as dynamic... in QlikView https://community.qlik.com/t5/QlikView/Can-any-one-help-to-do-this-expression-as-dynamic/m-p/841043#M1020925 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/RSRMachireddy">RSRMachireddy</A></STRONG>,</P><P>Do it Dates ,</P><P>Sum({&lt;Date={"&gt;= $(=Date(Addmonths(MonthStart(Max(Date)),-3))) &lt;= $(=Date(MonthStart(Max(Date))))"}&gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">COUNT</SPAN>)/3</P></BODY></HTML> Thu, 02 Apr 2015 07:44:54 GMT sibideepak 2015-04-02T07:44:54Z Can any one help to do this expression as dynamic... https://community.qlik.com/t5/QlikView/Can-any-one-help-to-do-this-expression-as-dynamic/m-p/841042#M1020924 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have challenge can any one pls help here....</P><P>i want feb month data based on&nbsp; </P><P>Jan, Dec, Nov and this has to be Dynamic when the months get added...</P><P>I just tried as Static like this...</P><P></P><P> (Sum({&lt;NumMonthYear ={'Jan 2014','Dec 2014','Nov 2014'} &gt;} COUNT))/3)</P><P></P><P></P><P>Thanks in advance...</P><P></P><P></P><P>Regards,</P><P>Raja.</P></BODY></HTML> Thu, 02 Apr 2015 07:00:38 GMT https://community.qlik.com/t5/QlikView/Can-any-one-help-to-do-this-expression-as-dynamic/m-p/841042#M1020924 2015-04-02T07:00:38Z Re: Can any one help to do this expression as dynamic... https://community.qlik.com/t5/QlikView/Can-any-one-help-to-do-this-expression-as-dynamic/m-p/841043#M1020925 <HTML><HEAD></HEAD><BODY><P>Hi <STRONG style="font-size: 11.6999998092651px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/RSRMachireddy">RSRMachireddy</A></STRONG>,</P><P>Do it Dates ,</P><P>Sum({&lt;Date={"&gt;= $(=Date(Addmonths(MonthStart(Max(Date)),-3))) &lt;= $(=Date(MonthStart(Max(Date))))"}&gt;} <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">COUNT</SPAN>)/3</P></BODY></HTML> Thu, 02 Apr 2015 07:44:54 GMT https://community.qlik.com/t5/QlikView/Can-any-one-help-to-do-this-expression-as-dynamic/m-p/841043#M1020925 sibideepak 2015-04-02T07:44:54Z