topic Re: How to add now function in line load table in qlikview...based on time stamp in QlikView

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

dolly777 — Wed, 09 Apr 2014 06:47:59 GMT

Hi All,

guide in this

Regards

Nirmala

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

MK_QSL — Wed, 09 Apr 2014 06:51:23 GMT

Create a variable like below

Let vStartTime = NOW();

before your inline table

and use vStartTime variable

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

Wed, 09 Apr 2014 06:52:44 GMT

PFA.

Thanks,

Ram

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

Wed, 09 Apr 2014 06:53:24 GMT

load name, age, now() as time;

load * inline

[

name, age

a,20

];

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

jagan — Wed, 09 Apr 2014 06:57:29 GMT

Hi,

Try like this

TableName:

load *,

Now() AS Timestamp

inline

[

Column1, Column2

Value1, Value2

];

Regards,

Jagan.

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

its_anandrjs — Wed, 09 Apr 2014 07:02:10 GMT

Please check i update now

Write a variable like

Let vTimeNow = NOW();

and use this in the inline table

TimeTable:

LOAD * Inline

[

Time

'$(vTimeNow )'

];

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

dolly777 — Wed, 09 Apr 2014 07:38:11 GMT

Hi Anand,

Time not displaying

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

Wed, 09 Apr 2014 08:26:52 GMT

Steal from previous answer

LET vTimeNow = NOW();

TableName:

load *,

Now() AS Timestamp2

inline

[

Column1, Column2,Timestamp

Value1, Value2,$(vTimeNow)

];

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

Wed, 09 Apr 2014 08:35:54 GMT

Try any of these

T1:

Load

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

AutoGenerate 1;

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

* Inline

[
TimeVar
$(vT)
];

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

dolly777 — Wed, 09 Apr 2014 09:21:28 GMT

Thank u

its working...

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

its_anandrjs — Wed, 09 Apr 2014 10:26:20 GMT

Oh its my mistake in variable check now with inline table with example

Let vTimeNow = Timestamp(NOW(),'hh:mm:ss');

TimeTable:

LOAD * Inline

[

Time

'$(vTimeNow)'

];

Regards

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

its_anandrjs — Wed, 09 Apr 2014 10:31:10 GMT

For timestamp you have to write like below script and for get time convertion use 'hh:mm:ss'

Let vTimeNow = Timestamp(Now( ),'hh:mm:ss');

TimeTable:

LOAD * Inline

[

Time

'$(vTimeNow)'

];

Regards

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

breno_morais — Fri, 10 Aug 2018 20:33:40 GMT

Thank you, helped me too.