Set Variables for Current Year and Month

jcampbell — Tue, 20 May 2014 18:07:45 GMT

Just wanted to share something I created recently for a project in QlikView 11. I need to store in Variables the current Year and Month. For comparison purposes I decided to also store the previous year too. First create the following Variables:

1. "vYear_Current"

2. "vYear_Previous"
3. "vMonth_Current"

Then add the following to your Load Script

LET vYear_Current = Year(Today());

LET vYear_Previous = Year(Today()) -1;

LET vMonth_Current = Month(Today());

Once you refresh the QVW those variables will populate with the current year, current month and previous year values based on the date of the local computer or server.

Re: Set Variables for Current Year and Month

Anonymous — Tue, 20 May 2014 21:03:19 GMT

Hi Joshua,

I think you should rename vMonth_Current into vMonth_Previous

Cheers,

Antoine

topic Re: Set Variables for Current Year and Month in QlikView

Set Variables for Current Year and Month

Re: Set Variables for Current Year and Month