Load excel file based on date selection

[Anonymous]

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?

[madhumitha]

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

[qliksus]

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 .