topic Re: How to create a load button? in QlikView

How to create a load button?

Thu, 24 Nov 2011 15:43:34 GMT

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

Re: How to create a load button?

Thu, 24 Nov 2011 20:41:30 GMT

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 ?

Re: How to create a load button?

Eugeny_Ilyin — Fri, 25 Nov 2011 06:56:02 GMT

How did you do it?

I could not find this action.

Best regards

Eugeny

Re: How to create a load button?

Fri, 25 Nov 2011 07:49:53 GMT

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

Re: How to create a load button?

Fri, 25 Nov 2011 07:53:52 GMT

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

Re: How to create a load button?

Eugeny_Ilyin — Fri, 25 Nov 2011 08:02:20 GMT

Thank you, Piskitta

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

Best regards

Eugeny

Re: How to create a load button?

Fri, 25 Nov 2011 08:09:21 GMT

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