Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
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 .