How to show previous month. help please.

[#1]

i want to show value of previous month. but i can't get it and i try follow by forums in qlikview community for this case but it dosen't work.

anyone help me please.

[Gysbert_Wassenaar · Accepted solution]

Probably easiest if you use some variables.

variable vPrevMonth: =date(addmonths(date#(TRANS_YEARMONTH,'YYYY-MM'),-1),'YYYY-MM')

expression: sum( {$<MONTH=,YEAR=,TRANS_YEARMONTH={'$(vPrevMonth)'},FS={'Sales',"Discount*"} >} DIFF )

See attached example.

To make things easier you can use Qlikview Components to create a calendar for you and get a lot of handy set modifiers (like previous month) for free. See Tutorial - Using Common Date Dimensions and Shared Calendars for more information.

[#3]

Thank you.