Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sivarajs
Specialist II
Specialist II

Reloadtime() in script

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);

7 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

jeffmartins
Partner - Creator II
Partner - Creator II

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

sivarajs
Specialist II
Specialist II
Author

Both solutions getting script reload failed

jeffmartins
Partner - Creator II
Partner - Creator II

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

Not applicable

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] ');

sivarajs
Specialist II
Specialist II
Author

Please reload the attched file you will get to know

Not applicable

Hi

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

Verify

"C:\users\your_user\desktop"