topic Re: Launch (action) text box in QlikView

Launch (action) text box

Tue, 25 Jun 2013 15:27:01 GMT

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.

Re: Launch (action) text box

shree909 — Tue, 25 Jun 2013 15:33:00 GMT

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

Re: Launch (action) text box

Tue, 25 Jun 2013 15:36:15 GMT

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.

Re: Launch (action) text box

Tue, 25 Jun 2013 16:22:49 GMT

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

Re: Launch (action) text box

Tue, 25 Jun 2013 18:21:21 GMT

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 sub

Just another way.

hth,

Stephen