Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sifatnabil
Specialist
Specialist

Load reloadtime() or now() as a field in script

Hi,

How can I use the value of reloadtime() and use it as a field within a table inside the load script?

I tried using let reloadtime = reloadtime() and then in the table:

test:

load reloadtime as loadtime;

Anyone know how? I need to know reloadtime() or now() and store it inside a QVD.

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

Let  ReloadTimeReloadTime();
LOAD '$(ReloadTime)' as ReloadTime AutoGenerate 1;

But its show the last reload time only. Not reload time.

i.e. This ReloadTime field value varies when u see the function value of ReloadTime() in textbox.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

Hi

Try like this

Let  ReloadTimeReloadTime();
LOAD '$(ReloadTime)' as ReloadTime AutoGenerate 1;

But its show the last reload time only. Not reload time.

i.e. This ReloadTime field value varies when u see the function value of ReloadTime() in textbox.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sifatnabil
Specialist
Specialist
Author

Thanks, I used now() instead and it worked!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Let  ReloadTimeReloadTime();
LOAD

'$(ReloadTime)' as ReloadTime

AutoGenerate 1;


LOAD

Now() as NowTime

AutoGenerate 1;


Regards,

Jagan.