Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikers,
I got a scenario where in when I select a date range using multibox, then in chart I need to get cosider next 15months posting date,
for example if we select date range of 201301 to 201306
then for 201301 posting date need to consider is from 201301 to next 15months(201402)
and for 201302 posting date need to consider is from 201302 to next 15months(201403)
.
,
and for 201306 posting date need to consider is from 201306 to next 15 months(201407)
Please find the attachment .
Thanks in advance.
Hi,
Please check the attached file.
Thanks,
Niranjan M.
Hi Samapthbotla,
sorry but I don't understand your request.
If you select periodo 2013-01 to 2013-06 do you want to sum for single date in X axis in chat the value of next 15 months?
So for 2013-01 you sum data in periodo 2013-01 to 201404
for 2013-02 you sum data in periodo 2013-01 to 201405
for 2013-03 you sum data in periodo 2013-01 to 201406
for 2013-04 you sum data in periodo 2013-01 to 201407
and so on?
Note: your model have sure some problem because all data are in islands.
Regards
Luca Jonathan Panetta