Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

NUM & NOW function in qlikview

LET vRuntime=num(now());


what is the meaning of above expression which is highlighted ?

why we used this expression ?.

28 Replies
qlikview979
Specialist
Specialist

Hi

which version  QV you are  using

for me its showing

do one thing, paste my script in your app.

check  these varibles  how its showing     (variable name changed) vRuntime,vRuntime1,vnum

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';



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

let vRuntime1=now();

let vnum=num(now());

annual:

LOAD DATE,

    MONTH,

    YEAR

FROM

D:\Qlikview\source\Data.xlsx

(ooxml, embedded labels, table is tbl_Date);

Anonymous
Not applicable
Author

still same, but the difference is runtime 2 shows old time whereas runtime shows current time.

Anonymous
Not applicable
Author

still same, but the difference is runtime 2 shows old time whereas runtime shows current time.

qlikview979
Specialist
Specialist

Which Version  you are using 11.2   or 12

qlikview979
Specialist
Specialist

For me its working fine,

Can any one help him

vinieme12

loveisfail

vinieme12
Champion III
Champion III

please post your script and your sample app

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

i have qlikview 11, btw leave it.

thank you so much.

Anil_Babu_Samineni

Seems Question answered, I am not sure where i need to reply

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sdhakare
Partner - Contributor
Partner - Contributor

now() gives you the current system's date and time &
num(now()) converts the current date and time into a number.