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 · Accepted solution]

Now() function returns the today's date with time

create variable check in input object  you can understand easily

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

let vRuntime1=now();

let vRuntime2=num(now());

LET vRuntime=num(now());(it will show the latest reload time )

[swuehl]

Now() is returning a dual value:

Data Types in QlikView

And Num() returns the numeric representation of the dual value.

[Anonymous]

but where it is shown? i am not able to find it.

[qlikview979]

I have Created these 3 variables in my back end.

[qlikview979]

Hi,

PFA

[Anonymous]

please send me screenshot becoz the file couldn't open in my qlikview.

[swuehl]

The LET statement is used in a Qlik LOAD script to create a variable.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatement...

If the variable is not deleted afterwards, you can see the variable in your frontend either by using the variable overview CTRL-ALT-V or by using an input box.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Variable_Overview_Dialog.htm

[Anonymous]

I found it.

thank you so much

[qlikview979]

Hi ,

this is help full to you

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

let vRuntime1=now();

let vRuntime2=num(now());

1) open new qlikview application in your system

2) copy the above  3 variables  and paste in your qlikview application and save the application

3) reload the application and save,right click  on mouse      New sheet object ---->Input box--->Add all---->Ok

then you will get the below result in your app.