Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
It it possible to launch a specific tab in a different qvw upon slecting a text box? I could manage to open an application but couldnot open a specific tab through Launch action.
Cheers
Koushik Vutha.
Found a solution.
Written a macro to read a text box and set a variable to trigger a value (sheet ID). When text box is selected it launches another qv application and calls the value (sheet ID) deifned in the text box
HI i think u can launch the differnt qvw from the textbox through external action.
if u want to open the sepecif tab of the differnet qvw u can save the applicaiton with the tab u want.
so when ever the application is launched the tab with the last saved version opens..
Thanks
Hi Shree
True. But I have 10 text boxes in one qvw and 10 tabs in other qvw. The above solution wouldnt apply to this scenario I suppose.
Found a solution.
Written a macro to read a text box and set a variable to trigger a value (sheet ID). When text box is selected it launches another qv application and calls the value (sheet ID) deifned in the text box
The hyperlink below opens the IE Plugin, opens a QlikView document and sends a variable that when the document is open it looks for the variable and opens a specific tab on the document.
http://QVServer/qvplugin/opendoc.htm?document=QVDocument.qvw?vOpeningSheet=2
This is the Macro that runs OnOpen
sub GoToMFSheet
set v = ActiveDocument.Variables ("vOpeningSheet")
if v.GetContent.String = "1" then
ActiveDocument.Sheets("SH44").Activate
v.SetContent "0", True
else
if v.GetContent.String = "2" then
ActiveDocument.Sheets("SH49").Activate
v.SetContent "0", True
else
v.SetContent "0", True
end if
end if
end sub
Just another way.
hth,
Stephen