topic date range selections in QlikView

date range selections

Thu, 11 Dec 2014 10:37:42 GMT

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.

Raj11 — Thu, 11 Dec 2014 12:09:03 GMT

Hi,

Please check the attached file.

Thanks,

Niranjan M.

Thu, 11 Dec 2014 13:19:20 GMT

Hi Experts,

Please give me any suggestions to overcome this.

Regards

pljsoftware — Fri, 12 Dec 2014 14:55:55 GMT

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