topic Re: Rolling 4 weeks logic in scripting in QlikView

Rolling 4 weeks logic in scripting

punitpopli — Sun, 14 Dec 2014 09:43:44 GMT

Dear Community,

I have created a calender in which we have data based on week ending date for 2 years and now i want to have rolling 4 weeks flag in the calendar script.

Does anyone had implemented the logic or can someone help on to achieve this?

Thanks in advance

Punit

Re: Rolling 4 weeks logic in scripting

Anonymous — Sun, 14 Dec 2014 10:14:05 GMT

Kinly add a sample QVW.

Re: Rolling 4 weeks logic in scripting

ecolomer — Sun, 14 Dec 2014 15:32:41 GMT

here you have some examples for months but is the same for weeks

Re: Rolling 4 weeks logic in scripting

punitpopli — Mon, 15 Dec 2014 07:34:44 GMT

Hi ecolomer,

Thanks for the QVW, but can we have the rolling (4 months/12 months and so on) indicators from Script based on the max date available? if yes could you please share the same.

Thanks in advance

Punit

Re: Rolling 4 weeks logic in scripting

ecolomer — Mon, 15 Dec 2014 12:40:59 GMT

You can select Max value of Month and select this, and automaticly you have the result