How to add now function in line load table in qlikview...based on time stamp

[dolly777]

Hi All,

guide in this

Regards

Nirmala

[MK_QSL]

Create a variable like below

Let vStartTime = NOW();

before your inline table

and use vStartTime variable

[#3]

PFA.

Thanks,

Ram

[#4]

load name, age, now() as time;

load * inline

[

name, age

a,20

];

[jagan]

Hi,

Try like this

TableName:

load *,

Now() AS Timestamp

inline

[

Column1, Column2

Value1, Value2

];

Regards,

Jagan.

[its_anandrjs]

Please check i update now

Write a variable like

Let vTimeNow = NOW();

and use this in the inline table

TimeTable:

LOAD * Inline

[

Time

'$(vTimeNow )'

];

[dolly777]

Hi Anand,

Time not displaying

[#8]

Steal from previous answer

LET vTimeNow = NOW();

TableName:

load *,

Now() AS Timestamp2

inline

[

Column1, Column2,Timestamp

Value1, Value2,$(vTimeNow)

];

[#9]

Try any of these

T1:

Load

Timestamp(Now(),'DD/MM/YYYY hh:mm:ss') as Time

AutoGenerate 1;

Or

Let vT = Timestamp(Now(),'DD/MM/YYYY hh:mm:ss');
T2:
Load

* Inline

[
TimeVar
$(vT)
];

[dolly777]

Thank u

its working...