topic Doubt on Calendar in QlikView

Doubt on Calendar

NavinReddy — Sat, 07 May 2016 19:55:08 GMT

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

Re: Doubt on Calendar

sunny_talwar — Sat, 07 May 2016 19:58:06 GMT

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

Re: Doubt on Calendar

NavinReddy — Sat, 07 May 2016 20:10:43 GMT

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

Re: Doubt on Calendar

sunny_talwar — Sat, 07 May 2016 20:20:17 GMT

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

Re: Doubt on Calendar

NavinReddy — Sat, 07 May 2016 20:27:39 GMT

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