Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Rolling 4 weeks logic in scripting

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

4 Replies
Highlighted
Creator II
Creator II

Re: Rolling 4 weeks logic in scripting

Kinly add a sample QVW.

Highlighted
Master II
Master II

Re: Rolling 4 weeks logic in scripting

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

Highlighted
Creator III
Creator III

Re: Rolling 4 weeks logic in scripting

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

Highlighted
Master II
Master II

Re: Rolling 4 weeks logic in scripting

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