Discussion board where members can get started with QlikView.
We have excel files having naming convention with date in it
Can I load the data from this excel file based on date selected by user?
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
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 .