Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Partner
Partner

How to calculate previous month ignoring other selection

I am calculating previous month date(AddMonths(date#(max([Months Number]),'YYYYMM'),-1),'YYYYMM') by using this formula for calculating previous month sales.

But when I am choosing any Rep id then the previous month calculation is going changed as per the rep id selection.

How to keep it fixed? Means I want the previous month is always max(month number)-1 irrespective of any selection.

Tags (2)