topic Re: NUM & NOW function in qlikview in QlikView

NUM & NOW function in qlikview

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

LET vRuntime=num(now());

what is the meaning of above expression which is highlighted ?

why we used this expression ?.

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 09:26:44 GMT

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 )

Re: NUM & NOW function in qlikview

swuehl — Wed, 17 May 2017 09:29:19 GMT

Now() is returning a dual value:

Data Types in QlikView

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

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 09:33:55 GMT

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

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 09:37:09 GMT

I have Created these 3 variables in my back end.

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 09:40:08 GMT

Hi,

PFA

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 09:47:47 GMT

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

Re: NUM & NOW function in qlikview

swuehl — Wed, 17 May 2017 09:52:51 GMT

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/ScriptRegularStatements/Let.htm

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

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 09:57:03 GMT

I found it.

thank you so much

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 10:03:59 GMT

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.

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 10:06:33 GMT

If you get the correct answer Click on Correct answer

i hope this is help full for others.

Regards

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 10:23:30 GMT

let vRuntime1=now();

let vRuntime2=num(now());

both are showing same result.

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 10:35:31 GMT

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.

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 10:49:43 GMT

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

let vRuntime1=now();

let vRuntime2=num(now());

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 10:55:59 GMT

Please share your file.

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 10:58:47 GMT

Hi,

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

it will give exact result.

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 11:00:39 GMT

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 11:04:01 GMT

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

Re: NUM & NOW function in qlikview

qlikview979 — Wed, 17 May 2017 11:05:50 GMT

Please share the Application

Re: NUM & NOW function in qlikview

Anonymous — Wed, 17 May 2017 11:14:33 GMT

please check attached file