topic Re: Transfer selection to variable in QlikView

Transfer selection to variable

dirk1955 — Wed, 23 Jan 2013 21:42:49 GMT

Hi,

I have a table wich contains file paths.

After the selection of a file path i want to transfer the selected file path to a variable wich i will use to load data from the selected file, via partitial load.

How can this be done?

I have included the qvw.

THX

Dirk

Re: Transfer selection to variable

Gysbert_Wassenaar — Thu, 24 Jan 2013 14:53:19 GMT

You can add a Set Variable action to the OnSelect trigger of the Field with the file paths. You can then use the variable in the load script for the partial reload. Something like:

Table1:

REPLACE ONLY LOAD * FROM [$(vFilePath)]

(biff, embedded labels, table is [Sheet1$]);

edit: see attached example

Re: Transfer selection to variable

dirk1955 — Thu, 24 Jan 2013 15:13:50 GMT

Hi,

"You can add a Set Variable action to the OnSelect trigger of the Field with the file paths."

Where can i do that?

Re: Transfer selection to variable

dirk1955 — Thu, 24 Jan 2013 15:53:01 GMT

THX, but thats what i already did in the uploaded example.

Everytime i get the same error, cannot open....

Re: Transfer selection to variable

Thu, 24 Jan 2013 20:04:57 GMT

You have the create the variable first. Create the variable from the variable overview dialog box; don't create it in the script since the value will be overwritten.

Re: Transfer selection to variable

dirk1955 — Thu, 24 Jan 2013 21:43:41 GMT

Hi,

Your example is working for me also.

But, what version of clickview are you using?

And: i don't see an action on the triggers tab of the sheet properties.

Furtermore i don't have the possibillity to add a button with the action reload or partial reload in the button properties action window.

Re: Transfer selection to variable

dirk1955 — Thu, 24 Jan 2013 21:44:15 GMT

Hi,

Your example is working for me also.

But, what version of clickview are you using?

And: i don't see an action on the triggers tab of the sheet properties.

Furtermore i don't have the possibillity to add a button with the action reload or partial reload in the button properties action window.

Re: Transfer selection to variable

Gysbert_Wassenaar — Fri, 25 Jan 2013 09:17:42 GMT

I'm using QV11. I've also tried my example in QV10 (SR3). In QV10 it's indeed not possible to add a reload action. It's not available. The interesting thing is however that the reload action I added using QV11 can still be used if the document is opened in QV10.

The triggers I added can be found on the Triggers tab of the document properties screen instead of on the sheet properties screen.

Re: Transfer selection to variable

dirk1955 — Fri, 25 Jan 2013 10:27:44 GMT

Thank you for the explanation, my problem is solved now.