topic Re: Document Chain - How to open a QVW with sheet ID in QlikView

Document Chain - How to open a QVW with sheet ID

posywang — Thu, 02 Feb 2017 01:25:47 GMT

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!

Re: Document Chain - How to open a QVW with sheet ID

vishsaggi — Thu, 02 Feb 2017 01:31:33 GMT

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.

Re: Document Chain - How to open a QVW with sheet ID

posywang — Thu, 02 Feb 2017 01:52:50 GMT

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?

Re: Document Chain - How to open a QVW with sheet ID

Thu, 02 Feb 2017 03:00:17 GMT

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

Re: Document Chain - How to open a QVW with sheet ID

posywang — Thu, 02 Feb 2017 03:28:05 GMT

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?

Re: Document Chain - How to open a QVW with sheet ID

Thu, 02 Feb 2017 03:31:01 GMT

can u share some sample files...

Re: Document Chain - How to open a QVW with sheet ID

posywang — Thu, 02 Feb 2017 03:39:01 GMT

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

Re: Document Chain - How to open a QVW with sheet ID

Thu, 02 Feb 2017 04:05:27 GMT

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

Re: Document Chain - How to open a QVW with sheet ID

posywang — Thu, 02 Feb 2017 04:14:50 GMT

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.

Re: Document Chain - How to open a QVW with sheet ID

Thu, 02 Feb 2017 05:46:02 GMT

WHEN HE CLICKED ON ONE BUTTON action will happen immediately ,

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

Re: Document Chain - How to open a QVW with sheet ID

Wed, 08 Feb 2017 10:34:23 GMT

if you get proper answer,you can close this thread ...

it might helpful for some one