Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

15 Replies
Not applicable
Author

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.

Not applicable
Author

Hi,

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

Not applicable
Author

Hi,

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

Regards,

Jagan

MayilVahanan

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
help4qv123
Creator II
Creator II

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

sujit_nath
Creator III
Creator III

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?