topic Re: Action for opening particular sheet of particular qlikview file in QlikView

Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 06:38:24 GMT

Hi All,

I have one app where i m showing the images of different reports and when i click on particular image i want to open the particular sheet of particular qlikivew file.

I know how to open the particular qlikview documet but i m wondering how will i open particular sheet of particular report by clicking on the image.

Anybody has any idea about it?

Thanks in advance

Re: Action for opening particular sheet of particular qlikview file

tresB — Mon, 07 Oct 2013 06:44:35 GMT

Use trigger: Activate Sheet

PFA

Edit: If you want to open a sheet from different application, then use trigger to open the new app and in that app use another trigger to open particular sheet using Activate Sheet, On Opening the appication action.

Re: Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 06:57:55 GMT

After open the qvw application use this macro in action

ActiveDicument.ActivateSheet 1 //1 is sheet no

Regards,

Kabilan K.

Re: Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 07:08:31 GMT

Are you saying that i should give the on image the the action for qlikview document and then in that qlikview document i should give the macro? Is it...?

Re: Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 07:13:47 GMT

Thanks tresesco, is there any direct way i can do this from one first application only insterad of giving on open action.

Because in our case the other application is also having many maore sheets and we have many such images for opening different sheets in the other qlikview application.

Re: Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 07:23:58 GMT

Hi,

set the images as a background in text object.

Create separate qlikview files for each image and go to the action property for the text object

External->Open qlikview document->Specify the name of the document you want to open for that image.

Create on button in each and every document and give the action to go back the main document contain images.

But it required more space...... If it's possible use it I hope it will helps you

Re: Action for opening particular sheet of particular qlikview file

tresB — Mon, 07 Oct 2013 07:30:30 GMT

Application1->Click on image1 : Open Application2->On Open -> Activate Sheet1
Click on image2 : Open Application2->On Open -> Activate Sheet2

Click on image3 : Open Application2->On Open -> Activate Sheet2

This way?

And it is always suggested to avoid macro. You should try with trigger AFAP.

Re: Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 07:41:23 GMT

For using triggers i have to create diffrerent version of same Application2fone for each sheet.Is it?

Re: Action for opening particular sheet of particular qlikview file

tresB — Mon, 07 Oct 2013 07:48:02 GMT

No. See, if you click on image1, you land up to application2's sheet1. So the clicking on the image is exclusive, if you click on image2, you can't click on image3 because you have landed in application2 by then. If you want to get back to application1 and click on another image, you have to use a trigger in application2.

Or, something else is there in your logical implementation? (may be i am not thinking of).

Re: Action for opening particular sheet of particular qlikview file

Mon, 07 Oct 2013 09:28:18 GMT

You are current in saying application 2 is already opened. In Our case images are from diffrent different applications and of different different reports from that.The target application is not fixed.So i want some thing which i can parametrized according to application name and associated sheet ID.

Re: Action for opening particular sheet of particular qlikview file

Tue, 08 Oct 2013 11:14:20 GMT

Can we do this with help of passing the parametre.?

I m not getting nay clue....

Re: Action for opening particular sheet of particular qlikview file

Wed, 30 Apr 2014 10:20:51 GMT

Hi Sneha,

To open a particular Sheet from other qvw.

Do the following Create A button -> Action -> 'Open QVW' (Set the Doc path)

Add another Action -> Layout -> Activate Sheet -> (Specify the name of the sheet you want to open from the above document)

**Note: Please keep all the sheet names unique in this case, unique across all the QVW's

Hope it helps

Regards,

Swapneel

Re: Action for opening particular sheet of particular qlikview file

Fri, 31 Jul 2015 21:51:06 GMT

Hi Swapneel

I want to open a new qvw file from other qvw by clicking sheet Title only. I've achived the functionality by creating button and corresponding action. Is it possible to click on sheet title and open other qlikview application.

Please help.

Thanks,

Manash

Re: Action for opening particular sheet of particular qlikview file

Anonymous — Wed, 08 Nov 2017 05:05:17 GMT

Thanks for the file tresesco‌