topic Load excel file based on date selection in QlikView

Load excel file based on date selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Load excel file based on date selection

madhumitha — Thu, 02 Nov 2017 02:55:56 GMT

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

Re: Load excel file based on date selection

qliksus — Thu, 02 Nov 2017 03:42:48 GMT

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 .