topic How to create current and last week as a variable in QlikView https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145203#M505637 <HTML><HEAD></HEAD><BODY><P>And, if you want to represent it as the date of week start:<BR />=weekstart(today())<BR />=weekstart(today()-7)<BR />Similar for week end. The possibilities are endless.</P></BODY></HTML> Wed, 27 May 2009 19:35:34 GMT Anonymous 2009-05-27T19:35:34Z How to create current and last week as a variable https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145199#M505633 <HTML><HEAD></HEAD><BODY><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-255_sourceID:255" /></P><P>Hi,</P><P>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??</P><P>Thanks for help.</P></BODY></HTML> Wed, 27 May 2009 18:55:00 GMT https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145199#M505633 2009-05-27T18:55:00Z How to create current and last week as a variable https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145200#M505634 <HTML><HEAD></HEAD><BODY><P>Matthias,</P><P>here you go:</P><P>vCurWeek: Put this in the Value field =Week(Today())</P><P>vLastWeek: =Week(Today())-1</P><P>Right?</P><P>Rainer</P></BODY></HTML> Wed, 27 May 2009 19:12:00 GMT https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145200#M505634 2009-05-27T19:12:00Z How to create current and last week as a variable https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145201#M505635 <HTML><HEAD></HEAD><BODY><P>Matthias,</P><P>Agree with Rainer, but if want more a format with the year inside, just use WeekName() instead of Week() function.</P><P></P><P>vCurWeek : =WeekName(Today())</P><P>vLastWeek : =WeekName(Today()-7)</P><P></P><P></P></BODY></HTML> Wed, 27 May 2009 19:17:10 GMT https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145201#M505635 2009-05-27T19:17:10Z How to create current and last week as a variable https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145202#M505636 <HTML><HEAD></HEAD><BODY><P>Thanks a lot.</P></BODY></HTML> Wed, 27 May 2009 19:35:27 GMT https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145202#M505636 2009-05-27T19:35:27Z How to create current and last week as a variable https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145203#M505637 <HTML><HEAD></HEAD><BODY><P>And, if you want to represent it as the date of week start:<BR />=weekstart(today())<BR />=weekstart(today()-7)<BR />Similar for week end. The possibilities are endless.</P></BODY></HTML> Wed, 27 May 2009 19:35:34 GMT https://community.qlik.com/t5/QlikView/How-to-create-current-and-last-week-as-a-variable/m-p/145203#M505637 Anonymous 2009-05-27T19:35:34Z