Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

date range selections

    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.

$@M

3 Replies
Raj11
Contributor III
Contributor III

Hi,

Please check the attached file.

Thanks,

Niranjan M.

Not applicable
Author

Hi Experts,

Please give me any suggestions to overcome this.

Regards

$@M

pljsoftware
Creator III
Creator III

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