topic Link to Button? in QlikView

Link to Button?

Tue, 16 Mar 2010 15:31:52 GMT

Hi;

i have 2 qvw file(a.qvw and b.qvw) and i have a 5 button in a.qvw file and they connect to b.qvw file
when i click button which is in a.qvw file i want to go to specfic sheet in b.qvw file
and these 5 buttons which is in a.qvw file have to go b.qvw files each sheets...[:'(]

ex:
button1(a.qvw) link to sheeta(b.qvw)

button2(a.qvw) link to sheetb(b.qvw)

button3(a.qvw) link to sheetc(b.qvw)

button4(a.qvw) link to sheetd(b.qvw)

button5 (a.qvw) link to sheete(b.qvw)

Thanks...

Link to Button?

vidyut — Tue, 16 Mar 2010 15:43:55 GMT

Hi,

It is possible to get the behaviour specified by you using the modified URL for opening QVW file. You could call a QVW document with additional parameters (macro name) to execute a macro while opening the document.

for example:

qvp://<ServerName>/<Folder>/DocumentName.qvw?MACRO=MacroSheet1

Link to Button?

Tue, 16 Mar 2010 15:44:42 GMT

You can add two actions to the button. The first open the other QVW document and the second action activates the correct sheet in that QVW document.

First action: External -> Open QlikView Document

Second action: Layout -> Activate Sheet

Link to Button?

Wed, 17 Mar 2010 10:12:59 GMT

Thanks for your responses...

How and where can i create macros for this button connections?
I know vbscript but i have never use macro in QV before!!!

could you help me about that please?

Link to Button?

Wed, 17 Mar 2010 13:10:49 GMT

use this macro in your " a.qvw "



sub xyz()
set app=activedocument.getapplication
set newdoc=app.opendoc("...\b.qvw","","")
newdoc.activatesheetbyid "sheet a"
end sub
call xyz()
[\code]

the above code will open the "sheet a " in b.qvw
if you want to open another sheet in "b.qvw" from "a.qvw" , create another button and write the same code as above with a little variation.
In the line // newdoc.activatesheetbyid "sheet b" //, use the "sheetname" which you want to open on clicking that particular button.
ex: newdoc.activatesheetbyid "sheet c"

thanks
 </body>

Link to Button?

Wed, 17 Mar 2010 13:17:45 GMT

use this macro in your " a.qvw "



sub xyz()
set app=activedocument.getapplication
set newdoc=app.opendoc("...\b.qvw","","")
newdoc.activatesheetbyid "SH02"
end sub
call xyz()
[\code]

the above code will open the sheet with sheetid "SH 02" in b.qvw
if you want to open another sheet in "b.qvw" from "a.qvw" , create another button in "a.qvw" and write the same code as above with a little variation.
In the line // newdoc.activatesheetbyid "SH02" //, use the "sheetid" of the sheet which you want to open on clicking that particular button.
ex: newdoc.activatesheetbyid "SH04"
thanks
 </body>

Link to Button?

Wed, 17 Mar 2010 14:11:54 GMT

Thank you so much tauqueer;

Thats all i need...