Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thank you.