Select a spreadsheet to load for analysis from a pop up menu

[tinkerz1]

Hi,

Is there any Qlikview mechanism to have a pop up menu open for a directory and then select the file or files you want to load for analysis, rather than typing in the spreadsheet name in a variable?

Thanks.

[swuehl]

Not really sure if I understand your request.

You should be able to select a file when using the table wizard in script editor (Tab 'Data', Button 'Table Files').

[tinkerz1]

I mean after that event you can set up a variable and put it in the load script.

Then you can change the name of the file and directory from typing in the variable.

But can this be done by opening a popup window like 'Open File for Upload' into variable?

[swuehl]

Maybe like

LET vFile = INPUT('Enter file name');

But this won't let you browse folders to select your file name, you need to enter the filename / path in the input box.

[richard_chilvers]

Interesting request which is similar to something I'm trying to do.

I'm wondering if it is possible to enter a filename in a variable and then do a partial RELOAD which uses the variable filename within the script.

Has anyone else tried this, before I take a look at it ?

[miguelbraga]

Hi Neil,

Maybe I'm wrong, but to me it seems that what you're looking for isn't possible. I think there is no trigger action to do this. Maybe using a VisualBasic macro in a button?

Regards,

MB

[tinkerz1]

I am thinking the same Miguel. open a menu in VBscript and select a file name and path

[miguelbraga]

Should be something to do with openfiledialog... Then print the value in a QlikView internal variable and/or show it in a input box. Maybe this way you can get what you want... Then use that variable in your Load Script