Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
learnQ
Contributor
Contributor

12 WEEKS OF ROLLING DATA IN BAR CHART

Hi All,

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

Thanks in advance,

Labels (6)
4 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, Something like this.

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

Prem0212
Creator
Creator

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
Contributor
Contributor
Author

Hi @Prem0212  

learnQ_0-1685346044254.png

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.