Discussion Board for collaboration related to Creating Analytics for QlikView.
I would like to create variables like current week and last week but the value of the variable should be calculated. How to do this??
Thanks for help.
Go to Solution.
Agree with Rainer, but if want more a format with the year inside, just use WeekName() instead of Week() function.
vCurWeek : =WeekName(Today())
vLastWeek : =WeekName(Today()-7)
here you go:
vCurWeek: Put this in the Value field =Week(Today())
Thanks a lot.
And, if you want to represent it as the date of week start:=weekstart(today())=weekstart(today()-7)Similar for week end. The possibilities are endless.