Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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