1 Reply Latest reply: Feb 12, 2013 11:36 AM by Stefan Wühl RSS

    Selecting File on Load

    Roberto Angelucci Feb 12, 2013 11:30 AM

      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

      • 87 Views
      • Tags:
        • Re: Selecting File on Load
          Stefan Wühl
          Stefan Wühl Feb 12, 2013 11:36 AM (in response to Roberto Angelucci)

          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;