topic How to calculate previous month ignoring other selection in QlikView https://community.qlik.com/t5/QlikView/How-to-calculate-previous-month-ignoring-other-selection/m-p/1377177#M817665 <HTML><HEAD></HEAD><BODY><P>I am calculating previous month <SPAN style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">date(AddMonths(date#(max([Months Number]),'YYYYMM'),-1),'YYYYMM')</SPAN> by using this formula for calculating previous month sales.</P><P>But when I am choosing any Rep id then the previous month calculation is going changed as per the rep id selection.</P><P>How to keep it fixed? Means I want the previous month is always max(month number)-1 irrespective of any selection.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT anindya_manna 2020-11-25T16:16:04Z How to calculate previous month ignoring other selection https://community.qlik.com/t5/QlikView/How-to-calculate-previous-month-ignoring-other-selection/m-p/1377177#M817665 <HTML><HEAD></HEAD><BODY><P>I am calculating previous month <SPAN style="color: black; font-family: 'Segoe UI',sans-serif; font-size: 10pt;">date(AddMonths(date#(max([Months Number]),'YYYYMM'),-1),'YYYYMM')</SPAN> by using this formula for calculating previous month sales.</P><P>But when I am choosing any Rep id then the previous month calculation is going changed as per the rep id selection.</P><P>How to keep it fixed? Means I want the previous month is always max(month number)-1 irrespective of any selection.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-calculate-previous-month-ignoring-other-selection/m-p/1377177#M817665 anindya_manna 2020-11-25T16:16:04Z