Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Doubt on Calendar

Hi Dear Experts,

i got the some script on community

im using two different scripts for Rolling 3 and Rolling 6  Months is there any way to implement in one script

need experts suggestions, below is the scripts

Rolling3 :

load 'Current' as Type,

Month as Rolling3,

Month as Month

Resident Calender;

Concatenate (Rolling3)

load 'Rolling 3' as Type,

Month as Rolling3,

Month + 1 - IterNo() as Month

Resident Calender

while IterNo() <= 3;

right join load Month Resident Calender;

Rolling6:

load 'Current' as Type,

Month as Rolling6,

Month as Month

Resident Calender;

Concatenate (Rolling6)

load 'Rolling 6' as Type,

Month as Rolling6,

Month + 1 - IterNo() as Month

Resident Calender

while IterNo() <= 6;

right join load Month Resident Calender;

Thanks,

Niranjan

4 Replies
sunny_talwar

Can you share the script where you are trying this? May be we can play around with it a little?

NavinReddy
Creator II
Creator II
Author

Hi Sunny,

Good Evening

i have attached sample application when im reloading its taking more time(5 Minutes)

is there any way without selections barchart how to display rolling3 and rolling6 months

Best Regards,

Niranjan

sunny_talwar

Good evening my friend. What do you mean when you say without selection show rolling 3Months and Rolling 6Months. Can you may be elaborate.


Best,

Sunny

NavinReddy
Creator II
Creator II
Author

i have to restrict barchart only for 3months, it should display every time 3months

based on month selections chart dynamically will change, please find the image for your reference, Thanks

rolling3Months.PNG