how to let open a new .qvw file from a sheet tab?

[#1]

Hi,

I need to create a new in qlikview file to open an another new .qvw file, once I click on the sheet tab.

lets say, I have 5 sheets in the current file, whenever I click on the last sheet tab, it has to open a new qlikview file.

plz help me...

thanks..

[klausskalts]

In Properties -> Triggers you should be able to add an external event whic opens another QlikView document.

[#3]

Yes I saw that,

In

Actions>External>Open Qlikview Document..

it asks for document, here is my question how to give my desired document here?

lets say my document is in 'c:/Documents and Settings/QV/newQV.qvw' location.

I tried giving 'c:/Documents and Settings/QV/newQV.qvw' but it didnt open. pls let me know how can i do that correctly....

[klausskalts]

It might be easier if you just add the command as an action to a number of different text-objects .... that will work.

[its_anandrjs]

Hi,

Yes you can open a different Qlikview Applications from the different location from single Qlikview application. See the attached sample for demo just try and create a folder in locations like "D:\Test Folder 1\App1.qvw" "and D:\Test Folder 2\App2.qvw" and try it.

Hope this helps you.

Regards,

Anand

[kaushiknsolanki · Accepted solution]

Hi,

    Here is the macro which will create a new sheet for you.

    Sub Create_tab

    set newsheet=ActiveDocument.CreateSheet

    set sp=newsheet.GetProperties

    sp.Name="New Tab"

    newsheet.setProperties sp

    newsheet.Activate

    End

    Place this at Macro editor ( Just predd Ctrl + m)

    Copy and paste the macro here.

    Once pasted just click on "Check"

    Now go to last sheet -> Right click and go to properties of last sheet

    Go to triggers

     Click on Add Actions under the OnActivateSheet

     Once clicked go to External -> Macro

     And type the Create_tab

    Click ok

    Now go to last sheet, a new sheet will be created for you.

Regards,

Kaushik Solanki

[#7]

Thank you Anand, but my requirement is without using any button.

ex. I have 2 .qvw files A & B... In A i have 3 sheets, wenever i click to open the 3rd sheet in A,  It should trigger B.qvw file with in the same or different window, without using any button...

[kaushiknsolanki]

Hi,

    For this. Goto the sheet properties (Last Sheet of A Qvw)

    Click on OnActivateSheet -> Add Action -> External -> Open Qlikview Application

    Pass the Full path with filename and extension.

    Also click on open in same window.

Regards,

Kaushik Solanki

[#9]

Kaushik, its working if i try with Button, but not this way.. i don't know why, guess somewhere we are going wrong...

[#10]

Hi,

Use this macro code in On Active Sheet trigger in sheet properties.

Mention the full path if the Qvw file is not in the same folder.

Sub OpenHome

    set App=ActiveDocument.GetApplication

    App.OpenDoc "Home.qvw","",""

    ActiveDocument.Save

    ActiveDocument.CloseDoc

End Sub

Let me know it is fine or not.

Regards...