How to create a load button?

[#1]

Hello everyone,

It's with great joy that I post my first question to the community.

I'm trying Qlikview only for a week and I find it  the most amazing thing in the world.

But since yesterday I''m having a big trouble with the creation of a button.

I want to select a file from a multibox and them click in the  button to load that file to QV.

I have the first part but i can't find the load button example. Is it possible to help me, please!

Thank you very much for your time.

Kind regards

piskitta

[#2 · Accepted solution]

Hi

Welcome to the community !

Look at this example just to see how to add an action-button with a reload.

How did you solve the first part of you question to  pass through a parameter in the script ?

JJ

[Eugeny_Ilyin]

Hi

How did you do it?

I could not find this action.

Best regards

Eugeny

[#4]

Hi Eugeny,

the code that i'm using is really simple:

In the actions of the button i use the set variable where i pick the current selection file with:

=right(GetCurrentSelections(), 10)

then i write a macro just to reload:

sub Reload

     ActiveDocument.Reload

end sub

I searched for the function reload also but i couldn't find it so i wrote a macro to do it.

I hope it helped a bit more.

Kind regards

Piskitta

[#5]

Hello Jean,

Sorry for taking such a long time for answering.

First of all, Thank you so much for your help. In the version 10 i can't find the reload function but as i wrote to Eugeny, I made a small macro to fix that problem.

I use this line to load the name of the files:

LOAD

  FileName() as FileName,

           FilePath() as Path,

           FileDir() as Dir   

FROM

(ooxml, embedded labels, table is Sheet1);

Then i list the names in a multibox.

Best regards

Piskitta

[Eugeny_Ilyin]

Thank you, Piskitta

But in an example from JJ it is not used macro.

Best regards

Eugeny

[#7]

You're welcome.

I know he didn't use a macro, but I don't have that function in my actions list... So I created it.

Best regards

Piskitta