topic Creating input dialogue to define input file in QlikView

Creating input dialogue to define input file

Thu, 15 Jul 2010 09:28:28 GMT

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?

Thu, 15 Jul 2010 09:50:21 GMT

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 — Thu, 15 Jul 2010 09:52:41 GMT

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.

Thu, 15 Jul 2010 10:06:24 GMT

exactly what I was looking for! Thank you