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

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

sifatnabil — Wed, 17 Sep 2014 03:25:31 GMT

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.

MayilVahanan — Wed, 17 Sep 2014 03:56:23 GMT

Try like this

Let ReloadTime= ReloadTime();
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.

sifatnabil — Wed, 17 Sep 2014 04:09:38 GMT

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

jagan — Wed, 17 Sep 2014 04:11:33 GMT

Hi,

Try like this

Let ReloadTime= ReloadTime();
LOAD

'$(ReloadTime)' as ReloadTime

AutoGenerate 1;

LOAD

Now() as NowTime

AutoGenerate 1;

Regards,

Jagan.