Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to get 12 weeks of rolling data in Bar Chart.
Thanks in advance,
Hi, Something like this.
Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=WeekStart(Max(Date), -11))<=$(=Date(Max(Date)))’}>} Sales )
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
Hi @Prem0212
I have used your solution, but I'm getting entire data
Can you please help me with this.
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