Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

vSetWeeklyPrev doesn't work

Hello I have this variable :

vSetWeeklyPrev :

[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ])-$1)}, [%Date ID] = { "<= $(=max([%Date ID]) -7)"}

it doesn't work

On the another hand

the vSetWeeklyPres work :

[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ]))}, [%Date ID] = { "<= $(=max([%Date ID]))"}

What's the problem with the vSetWeeklyPrev ?

Thank you

Regards

Zied

2 Replies
jpar0511
Contributor III
Contributor III

Just a suggestion:

[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ])-1)}, [%Date ID] = { "<= $(=max([%Date ID]) -7)"}

zied_ahmed1
Specialist
Specialist
Author

thanks for your answer, my expression when i don't select any week of date the Prev works,so i would like when i choose a week of date for example week of date 3 of April the prev display the value for week of date 2