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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
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