Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all, I'm pretty new to QlikSense and I need to add a variable to add 30 minutes to my current time. The problem is I found out two different ways for this:
Option1.
LET vDate10min = Date(Now() - MakeTime(00,30),'DD/MM/YYYY hh:mm')
Option2.
LET vDate10min = Date(Now() - 30/24/60,'DD/MM/YYYY hh:mm')
Both one returns me the same, in fact, I checked the result of 30/24/60 and Num(Maketime(00,30)) and it's the same too.
Can someone explain the second option? I don't understand why 30/24/60 is the same to Num(MakeTime(00,30))
Is it one way better than another?
hi
30/24/60 help to convert numeric value into minutes time value
30 is the number of minutes you want to convert into time value that is divided by
24 ( hours in a day)
60 (minutes in an hour)
So
30/24/60 give 0.2
if you use time(0.2) it will give 00:30:00
then maketime(00,30) creates the same 00:30:00
hop it helps
hi
30/24/60 help to convert numeric value into minutes time value
30 is the number of minutes you want to convert into time value that is divided by
24 ( hours in a day)
60 (minutes in an hour)
So
30/24/60 give 0.2
if you use time(0.2) it will give 00:30:00
then maketime(00,30) creates the same 00:30:00
hop it helps