Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Bart_Breekveldt
New Contributor III

Rolling weeks next year

Dear Community,

I want to see certain orders (Amount) for in total 52 weeks, of which three are ahead and one is the current week. For that I made this formula of the rolling weeks. 

=IF(Week([Datefield])>=Week(Date(Today()+28)),IF(WeekYear(Today())=WeekYear([Datefield]),'W-'&Num(Week([Datefield]),00)),IF(Week([Datefield])<Week(Date(Today()+28)),WeekYear(Today())+1&' W-'&Num(Week([Datefield]),00)))

However, W-01 in 2020 doesn't connect with the other data (Amount, Weeks) (and therefore doesn't sort on Max(Datefield)

Qlik Rolling Amount.PNG

How can I solve this?

Thanks in advance.

1 Reply
Highlighted
andoryuu
Contributor III

Re: Rolling weeks next year

I wrote the accepted solution to an extremely similar situation yesterday.  Have a look and let me know if you still need help adapting to your rolling week and sorting needs.