topic Re: How to open a specific sheet of another application from an existing application in QlikView

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

Sun, 07 Jun 2015 14:44:17 GMT

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

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

MayilVahanan — Mon, 08 Jun 2015 04:42:06 GMT

May be try like this

ABC.qvw text box -> Action -> External -> Open Qlikview Document

Document -> XYZ.qvw

In XYZ.qvw , Document Properties -> OnOpen trigger -> Layout -> Activate Sheet

Sheet ID -> SH02.

its static method.

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

help4qv123 — Mon, 08 Jun 2015 05:04:24 GMT

Hi Mr Rao,

If u got the ans. Please mark it as a correct ans. so that other people will know. What Ramasamy told id right.

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

Anonymous — Mon, 08 Jun 2015 05:37:09 GMT

Try Document chaining as mentioned by Ramaswamy

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

Mon, 08 Jun 2015 05:50:14 GMT

Hi Ramaswamy,

Thanks for your solution. This is helpful. I got a new requirement now on the same aspect. Here, I need to create three text boxes. Each Text box/button should be linked to different sheets of XYZ.qvw. For example, 1st tab should be linked to Sheet 1, second tab to Sheet 2 and third tab to Sheet 3. How can I do that?

Thanks in advance for your help.

Regards,

Jagan

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

help4qv123 — Mon, 08 Jun 2015 05:57:04 GMT

u can do in the same way as ramaswamy given u an ans. it was for 1 button. same way u can create more to buttons and link to those.

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

help4qv123 — Mon, 08 Jun 2015 06:00:52 GMT

Hi,

Give me your mail id. so that i can help u

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

Mon, 08 Jun 2015 06:04:28 GMT

Hi,

I am sorry, I did not completely understand how to do that for other buttons. It would be great if you can elaborate on that. Ramaswamy mentioned that after setting the action in the first document, I need to open XYZ.qvw and set the trigger. If that is the case, how can I do it for the second button, as the 'Open trigger' is already given in XYZ.qvw? Can we give multiple triggers in XYZ.qvw (second document)?

Regards,

Jagan

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

MayilVahanan — Mon, 08 Jun 2015 06:19:35 GMT

Try like attachment.

Hope it give idea for you.

Regards,

Mayil Vahanan R

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

help4qv123 — Mon, 08 Jun 2015 06:21:50 GMT

can u create 3 different xyz.qvw

1 will be for 1st button and 2nd for 2nd button and so on....

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

Mon, 08 Jun 2015 06:29:33 GMT

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.

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

Mon, 08 Jun 2015 06:30:12 GMT

Hi,

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

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

Mon, 08 Jun 2015 06:34:44 GMT

Hi,

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

Regards,

Jagan

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

MayilVahanan — Mon, 08 Jun 2015 06:43:04 GMT

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

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

help4qv123 — Mon, 08 Jun 2015 06:46:51 GMT

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

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

sujit_nath — Tue, 25 Aug 2020 08:44:39 GMT

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?