Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
I realize there's a few posts regarding rolling views and I've tried some of the sample code (using rangesum and couple of other examples), but none quite work for me, but that could be my fault as I'm still new to Qlikview.
What I'm looking to do is create a stacked bar chart that would be comprised of a Business, i.e. Business1, Business2, etc. on top of each other in the chart, showing 13 months of billing information. I pull the data directly from a database into Qlikview.
The fields I have are:
Business1 through to Business10 - Easy enough to get this part
CHARGE_AMOUNT - A dollar based figure I would need to sum for each month
CHARGE_MONTH in the form YYYYMM, i.e. 201609 - For the 13 month rolling view, if ran today, I'd like to see 201509 through 201609. Next month I would want to see 201510 through 201610. Etc.
I'm essentially stuck on creating the formula / expression to do this. Any help would be greatly appreciated. Thanks in advance.
Hi Perry
Once we are into October you will be able to see 201510 through 201610.
Please let me know if it doesn't work.
Regards
Harish
Will do. Thank you again.
NP. In case if you feel its working as you expected try to mark it as correct or useful answer.
Regards
Harish
Hello Harish:
I wanted to give you an update. I have reloaded the data and I still see 201509 through 201609. However, that could be because I don't have any 201610 charges yet and won't until the end of the month. I will go ahead and mark your answer as the correct one and if after loading 201610 data, I don't see 201510 through 201610, I'll let you know. Thanks again for your help.