Get previous month and the month behind previous month based on max(date)

[Anonymous]

Hi,

I need to get my previous month and the month behind previous month with respect to my max(date). This is required for me to show the last 3 month trends in my chart.

My max(Date)='01-08-2018'

Please provide a solution.

[ashwin_r]

HI,

Use AddMonths() function ..

Regards,

Ashwin.

[qlikviewwizard · Accepted solution]

Hi,

Check this.

Sum( {$<MonthYear={"$(=Date(AddMonths(Max(MonthYear),-1),'MMM-YY'))"}>} LineSalesAmount )

Read for more details: A Primer on Set Analysis

[jyothish8807]

Hi Aravind,

Try like this:

Sum( {$<Date={">=$(=Date(monthstart(AddMonths(Max(Date),-2)),'DD-MM-YYYY')) <=$(=Date(max(Date),'DD-MM-YYYY'))"}>} Sales )

Br,

KC

[Anonymous]

Hey Arjun,

Thank you so much. I got the output.