NUM & NOW function in qlikview

[Anonymous]

LET vRuntime=num(now());

what is the meaning of above expression which is highlighted ?

why we used this expression ?.

[qlikview979]

If you get the correct answer Click on Correct answer

i hope this is help full for others.

Regards

[Anonymous]

let vRuntime1=now();

let vRuntime2=num(now());

both are showing same result.

[qlikview979]

Hi ,

Check my above screen shot

let vRuntime1=now();               :- it was showing Date with time format

let vRuntime2=num(now());     :- it was showing Number  format.

if  u replace instead num(now())  with Date(num(now()))   it will give only Date format.

[Anonymous]

LET vRuntime=Date(num(now()));                                OUTPUT:

let vRuntime1=now();

let vRuntime2=num(now());

[qlikview979]

Please share your file.

[qlikview979]

Hi,

from your input box remove the 1,2,4 variables then check,

it will give exact result.

[Anonymous]

still same, but when i  change number properties for rumtime2 is mixed then it shows in number format  whereas runtime1 give the date & time.

[qlikview979]

Please share the Application

[Anonymous]

please check attached file