https://community.qlik.com/t5/QlikView/Previous-month-expression/m-p/1588033#M456657 <P>hi all,</P><P>in my model i have a straight table ,</P><P>i want to present dims and expression that will respond to user selection and one expression that will calculate previous month value based on current selection .</P><P>created a field in script as below :</P><P>AddMonths((MakeDate(xyear,xmonth,01)),-2) as the_prev_date,</P><P>and in the table expression :</P><P>=Sum({&lt;the_date=p(the_prev_date),xyear=,xmonth=&gt;}amount)</P><P>it retrieves the correct value , but it changes all the dims and expressions to the previous month disregarding selections ..</P><P>any ideas ?</P><P>advanced thanks&nbsp;</P> Tue, 04 Jun 2019 10:29:59 GMT ilanbaruch 2019-06-04T10:29:59Z https://community.qlik.com/t5/QlikView/Previous-month-expression/m-p/1588033#M456657 <P>hi all,</P><P>in my model i have a straight table ,</P><P>i want to present dims and expression that will respond to user selection and one expression that will calculate previous month value based on current selection .</P><P>created a field in script as below :</P><P>AddMonths((MakeDate(xyear,xmonth,01)),-2) as the_prev_date,</P><P>and in the table expression :</P><P>=Sum({&lt;the_date=p(the_prev_date),xyear=,xmonth=&gt;}amount)</P><P>it retrieves the correct value , but it changes all the dims and expressions to the previous month disregarding selections ..</P><P>any ideas ?</P><P>advanced thanks&nbsp;</P> Tue, 04 Jun 2019 10:29:59 GMT https://community.qlik.com/t5/QlikView/Previous-month-expression/m-p/1588033#M456657 ilanbaruch 2019-06-04T10:29:59Z