Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi
How did you do it?
I could not find this action.
Best regards
Eugeny
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
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
Thank you, Piskitta
But in an example from JJ it is not used macro.
Best regards
Eugeny
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