topic Re: Reloadtime() in script in QlikView

Reloadtime() in script

sivarajs — Tue, 05 Feb 2013 13:58:58 GMT

Hi,

I am curious to know why

Let vVar= Reloadtime(); is working and why not when am using same in

Let vVar1='C:\Desktop\'&reloadtime(); or Let vVar1='C:\Desktop\'&$(vVar);

Re: Reloadtime() in script

jagan — Tue, 05 Feb 2013 14:45:59 GMT

Hi Sivaraj,

Check this its workding

Let vVar= Reloadtime();

Let vVar1='C:\Desktop\'& "'" & reloadtime() & "'" ;

I think Single quotes is missing in your expression while concatenating. ReloadTime is considering as number, by concatenating single quotes it is becoming string.

Hope this helps you.

Regards,

Jagan.

Re: Reloadtime() in script

jeffmartins — Tue, 05 Feb 2013 14:48:42 GMT

Hi Sivaraj Seeman,

It works if you convert the values to text before of concatenating the strings.

Let vVar= Reloadtime();

Let vVar1='C:\Desktop\'&text(reloadtime());

Let vVar2='C:\Desktop\'&'$(vVar)';

Regards

Re: Reloadtime() in script

sivarajs — Wed, 06 Feb 2013 07:15:43 GMT

Both solutions getting script reload failed

Re: Reloadtime() in script

jeffmartins — Wed, 06 Feb 2013 11:18:49 GMT

Hi Sivaraj Seeman,

It works if you convert the values to text before of concatenating the strings.

Let vVar= Reloadtime();

Let vVar1='C:\Desktop\'&text(reloadtime());

Let vVar2='C:\Desktop\'&'$(vVar)';

I've updated this post with an example.

See the attached file. Hope this helps you.

Regards

Re: Reloadtime() in script

Wed, 06 Feb 2013 11:34:05 GMT

Hi,

If you are using the value of RELOADTIME () to create a file, remember that you can not create files using certain characters in their name.

If you need to generate a file, use your example removing the special characters with the DATE () function

ex.:

Let vVar1 = 'C: \ Desktop \ "& DATE (reloadtime (),' YYYYMMDD_hhmmss [. Fff] ');

Re: Reloadtime() in script

sivarajs — Wed, 06 Feb 2013 13:16:17 GMT

Please reload the attched file you will get to know

Re: Reloadtime() in script

Wed, 06 Feb 2013 13:25:32 GMT

this directory doesn't exists "C:\Desktop"

Verify

"C:\users\your_user\desktop"