Document Chain - How to open a QVW with sheet ID

[posywang]

Hi,

I have multiple QVWs saved in my local C drive. Each QVW has multiple sheets. I plan to create a portal with bunch of buttons and assign link to open these QVWs with defined sheet ID. However, it seems that "Open Qlikview Document" action doesn't support sheet ID. How can I do it? Thanks!

[vishsaggi]

How many QVW's you have? One way is to create an On Open trigger from document properties of each qvw files you have and just use these buttons just open those QVW files. Hope you got me?

Like you have 3 QVW files

Step1: Create on open trigger in each of these QVW files File1.QVW, File2.QVW and File3.QVW for example.

Step2: When you create buttons just link these files to individual buttons. So when ever a file is opened based on on open trigger it will activate the sheet.

Let us know if that helps.

[posywang]

Let's say we have button 1 to open Sheet 01 of File1.QVW and button 2 to open Sheet 02 of File1.QVW, how can I do it?

[#4]

Hi ,

Try like this

u have button 1 to open File1.qvw and give one more action in file1.qvw using document trigger on open activate sheet id -sh01

[posywang]

How can I open sheet 2 of file1.qvw with button 2 if I have open activate sheet id set to sh01 in file1.qvw?

[#6]

can u share some sample files...

[posywang]

Please see attached. All 3 QVWs are in the same folder.

[#8 · Accepted solution]

hI,

CREATE ONE DUMMY FIELD FOR SELECTION

LIKE I HAVE CREATED A TMP FIELD IN BOTH APPLICATIONS  , PLS HAVE A LOOK AND LET ME KNOW

[posywang]

Thanks! Is there a way to show both sheets since users may click both buttons and want to see sheet 1 and sheet 2 side by side.

[#10]

WHEN HE CLICKED ON ONE BUTTON action will happen immediately ,

so I don't think he will click on 2 buttonds