Creating input dialogue to define input file

[#1]

Hello,

I did not really know how to search for this issue:

The .qvw is based on several excel tables which contain the master data. For the report, I have to load a flatfile:

LOAD .....
FROM
Sourcefiles\Source1.log
(txt, codepage is 1252, no labels, delimiter is spaces);

Is it possible to set a input dialogue or something, so the user can change the source file path without editing the script?

[#2]

You can add an input Field in Qlikview.

Then you use the variable in this input field to reload the file from

Example Create an input field and create a new variable called pathText

Then LOAD ...

FROM $(PathText)

(txt,codepage is 1252, ...)

Rgds,

[Anonymous · Accepted solution]

Hi kaweeche,

Yes, this is possible using the Input() function. Example:

Let vVar = Input('Enter value', 'Input box');

Load
Field1,
Field2
from '$(vVar)';

You assign the value from the input box to the vVar variable and then use that in the load statement as the "from" part.

[#4]

exactly what I was looking for! Thank you