12 WEEKS OF ROLLING DATA IN BAR CHART

[learnQ]

Hi All,

How to get 12 weeks of rolling data in Bar Chart.

Thanks in advance,

[BrunPierre]

Hi, Something like this.

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -11))<=$(=Date(Max(Date)))’}>} Sales )

[Prem0212]

I think this expression will work for you.

Sum({<[Order Date]={">=$(=Date(Max([Order Date])-84), 'YYYY-MM-DD')<=$(=Date(Max([Order Date]), 'YYYY-MM-DD'))"}>}Sales)

Please like and accept the solution if u find the needful

[learnQ]

Hi @Prem0212  

I have used your solution, but I'm getting entire data 

Can you please help me with this.

[vikasmahajan]

Hi,

you can implement Sunny's solution here :

https://community.qlik.com/t5/QlikView-App-Dev/Rolling-12-Weeks/m-p/1012164

or  by creating flag

https://community.qlik.com/t5/New-to-Qlik-Sense/Rolling-Weeks-Question/td-p/1003093

or 

https://community.qlik.com/t5/App-Development/Rolling-Weeks-Sorting/td-p/1655507

Vikas