How to open a specific sheet of another application from an existing application

[#1]

Hi,

I have an application in which I need to create a text box/button, clicking on the same has to open a specific sheet of another application. For example, I am working on ABC.qvw and I create a text box/button wherein which, I click on the same, and it has to open Sheet (SH02) of XYZ.qvw. Both these applications are in my local folder. I have the application saved in my local folder as C:\Leads\City Project\4.App\XYZ.qvw.

Can someone help me with the same?

Regards,

Jagan

[#2]

I have tried it earlier in the same way that you mentioned by creating 3 different files, but the Client does not want that. He needs only one XYZ.qvw.

[#3]

Hi,

My email id is jagan_knvs@yahoo.com. Please help me with this.

[#4]

Hi,

It would be great if you can elaborate on your suggestion 'Try like attachment'.

Regards,

Jagan

[MayilVahanan · Accepted solution]

Hi

Created a field name as "Sheet" and its contains the Sheet Ids value in both qv files.

In qv1 file:

Created 3 text object and contain 2 actions.

1. Select in field : Sheet -> SH01 (Sheet Id), similarly for sheet 2 n sheet 3 in corresponding text boxes.

2. Open the qlikview document with Transfer state (checkbox).

In qv2 file:

- Contains 3 sheets.

- In Sheet properties -> General -> Show sheet -> Conditional =MaxString(Sheet)='SH01'

     (Similarly for next 2 sheet). Save the file n close it.

Open the qv1 file, and select the textbox, its will show the corresponding sheet in qv2 file.

Hope it helps

[help4qv123]

check the condition of sheet. try to put some condition as ramaswamy did

[sujit_nath]

I have a QVW file where I have 2 buttons. Basically both of these buttons should take me to different sheets of a different QVW. How do I achieve that?

To re iterate -

QVW 1-> has 2 sheets, SH01 and SH02 (This is where I want to navigate to)

QVW2 -> has two buttons,

button1 should take me to QVW1 and activate SH01

button2 should take me to QVW1 and activate SH02

If I am setting two actions on the button, open Qlikview document and second to set the variable to activate the sheet, it does not take the second action and brings me to the other QVW without sheet selection. How do I achieve this?

[sujit_nath]

I have a QVW file where I have 2 buttons. Basically both of these buttons should take me to different sheets of a different QVW. How do I achieve that?

To re iterate -

QVW 1-> has 2 sheets, SH01 and SH02 (This is where I want to navigate to)

QVW2 -> has two buttons,

button1 should take me to QVW1 and activate SH01

button2 should take me to QVW1 and activate SH02

If I am setting two actions on the button, open Qlikview document and second to set the variable to activate the sheet, it does not take the second action and brings me to the other QVW without sheet selection. How do I achieve this?