Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Selecting File on Load

I have a file that has a date embedded in the file name. Eg File_20120101.csv. I have the same file with different dates. What I would like to do in Qlikview is have the ability to select the file to load when I reload data. So in essence I am asking if there is a way to code Qlikview to ask the user to select a file rather than hard code it. Is this possible?

thx

Roberto

1 Reply
swuehl
Not applicable

Re: Selecting File on Load

Not sure if this is of great help, but there is a system function to query the user from the script:

Input(str cue [, str caption])

This function can be used in the script only and opens an input box that prompts the user for a value during the script execution. The parameters cue and caption are used as message and caption texts, respectively. The function returns the entered value.

The input box function returns NULL if the dialog is cancelled, closed or cannot be shown.

Example:

Load
Input('Enter value', 'Input box') as v,
Recno () as r
autogenerate 3;