Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Load excel file based on date selection

We have excel files having naming convention with date in it

prdmaster_20171001.xlsx

prdmaster_20171002.xlsx

prdmaster_20171003.xlsx

prdmaster_20171004.xlsx

Can I load the data from this excel file based on date selected by user?

2 Replies
Creator
Creator

Hi Patel,

There are couple of workarounds. 

1) load all excel files withdraw as name. In the active qvw you can use document trigger to load the qvd based on the filter selection.

2) use a excel file and get the users enter the date. Monitor changes in the file thro bat and use edx to read your excel and inturn the excel with the date

Specialist II
Specialist II

Is your requirement is to show the data for the selected values?  If so why cant you just load all the data and just use selections to show the data the user want to see .