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: 
vignesh_s
Creator
Creator

variables

hi  all,

step 1:

i have a date excel file which as dates in  it and i loaded it

ex:

Date:

12-jan-2018

13-jan-2018

step 2:

now i want set variable to store the above date

Step 3:

i want to load the file

ex:

load *

from [..//xyz_12jan2018.xsl]

but instead of file name 12jan2018.xsl i wanna use variable set on step 2, how can i achive that,it used happen dynamically

11 Replies
shiveshsingh
Master
Master

U need to convert it into desired format using Date(Date#...

vignesh_s
Creator
Creator
Author

hi attached text file hope it may understand clearly