Discussion Board for collaboration related to Creating Analytics for QlikView.
Hi, need some help on date / Makedate
If i read a excel file with a "date" column (number formated as a date) into a variable, this variable get's the number representing the date.
If i create a variable with makedate(yyyy,mm,dd) i get dd/mm/yyyy ( my date mask is DateFormat='DD/MM/YYYY' )
how do i do to create this variable as a number, like i had got reading from the excel file?
I believe this question of variables and the use of them in code and set expresssions is very confusing.
Go to Solution.
If you want to convert your date to a number, use
Let vDate = num(makedate(yyyy,mm,dd));
in your variable definition. (Or num('$(vDate)') in any expression using your original variable should work, too.)
Or use date() function to format your excel date field:
Date(EXCELFIELD) as Date,
Hope this helps,
Use Num() to convert date to number format.