topic Re: how can i go to specific sheet? in QlikView

how can i go to specific sheet?

Mon, 15 Sep 2014 05:53:50 GMT

hi all,

i have open emp.qvw ,in emp document i have created one button.if i select open new sal.qvw document will be open.

but i have one question i have 4 sheets in sal.qvw like shee1,sheet2,sheet3,sheet4.

if select button i need to go directly to sheet3 in sal.qvw .

can you please help me how can i write condition?

Re: how can i go to specific sheet?

deepakqlikview_123 — Mon, 15 Sep 2014 05:58:08 GMT

use button object active sheet and put respected sheet id in it.

You can navigate to that perticular sheet.

If you habve 4 sheets then you can use 4 buttons.

Thanks

Re: how can i go to specific sheet?

rido1421 — Mon, 15 Sep 2014 06:03:50 GMT

you could just save Sal.qvw on sheet 3... when you open it will open on sheet 3.

Re: how can i go to specific sheet?

dinuwanbr — Mon, 15 Sep 2014 06:07:39 GMT

Hi,

Create 4 button ans give the action as follow. Each button having a separate action to activate separate sheet.

BR,

Dinu1

Re: how can i go to specific sheet?

MayilVahanan — Mon, 15 Sep 2014 06:09:58 GMT

Try like this

Button properties -> Actions -> Add action

Action Type: Layout

Action: Activate Sheet

Enter yout Sheet ID (Specify the sheet id to navigate)

Re: how can i go to specific sheet?

SunilChauhan — Mon, 15 Sep 2014 06:11:25 GMT

one thing you can do save the application on particular sheet

and then redirect to this application

Re: how can i go to specific sheet?

ashfaq_haseeb — Mon, 15 Sep 2014 06:20:13 GMT

Hi,

I don't think this can be done directly with a button(Open Application Trigger).

Instead I snuggest you to use URL and you can pass parameters to open sheet.

At the end of url add this

&sheet=SH01

Let me know if that worked.

Regards

ASHFAQ

Re: how can i go to specific sheet?

pradnyat — Mon, 15 Sep 2014 07:09:00 GMT

Hi Sanjeev,

On button write action to 'Open QlikView Document' and give sal.qvw there.

and in sal.qvw application go to document properies and in trigger-->

On open trigger, write action:

activate sheet (Sheet 3).

So when u will click on the button it will redirect you to sal.qvw application and because of trigeer it will open sheet 3 directly.

Hope this will help you.

Re: how can i go to specific sheet?

Mon, 15 Sep 2014 08:55:39 GMT

thanks for help but how can i give both in actions one for opening document and another for opening sheet4?.

i need to place in one action then only it will be work directly to connect sheet4 when i click on button.

please send me the exact condition

Re: how can i go to specific sheet?

pradnyat — Mon, 15 Sep 2014 09:06:36 GMT

Hi Sanjeev,

In button present in emp.qvw, write the below action :

Open QlikView document. (Sal.qvw)

In sal.qvw application:

Go to document properties --> Triggers --> On Open --> Activate Sheet (Sheet 4)

Re: how can i go to specific sheet?

Mon, 15 Sep 2014 09:18:41 GMT

it is not working

Re: how can i go to specific sheet?

ashfaq_haseeb — Mon, 15 Sep 2014 09:21:13 GMT

Hi,

Did you check my reply.

Regards

ASHFAQ

Re: Re: how can i go to specific sheet?

pradnyat — Mon, 15 Sep 2014 09:28:40 GMT

Hi,

Please find the attached qvw files for both Emp and Sal.

Re: Re: how can i go to specific sheet?

Mon, 15 Sep 2014 09:43:28 GMT

can you please check from your end once??

Re: how can i go to specific sheet?

pradnyat — Mon, 15 Sep 2014 09:46:26 GMT

Yeah, It is working.

Open the Emp application first.

What error you are facing in those applications?

Re: how can i go to specific sheet?

Mon, 15 Sep 2014 10:06:21 GMT

when i clickon button it opening home page directly not opening sheet4.

Re: how can i go to specific sheet?

pradnyat — Mon, 15 Sep 2014 10:16:18 GMT

No...It is opening sheet 4 directly in sal.qvw for me.

Re: how can i go to specific sheet?

sunilkumarqv — Mon, 15 Sep 2014 10:23:27 GMT

Hi sanjeev,

Hope this will hepls your reqiurment. please find the attached file for your ref..

Re: how can i go to specific sheet?

Anonymous — Mon, 15 Sep 2014 10:54:44 GMT

Hi Sanjeev,

It should not be directly supporting, however if you want to access second qvw through accesspoint, below discussion thread should help you.

Passing Parameters in a URL and Document Chaining

Regards,

Nita Prasad

Re: how can i go to specific sheet?

Mon, 15 Sep 2014 12:57:59 GMT

Hello Sanjeev,

Try to add Trigger (On Open) to activate specific sheet on sal.qvw.

in emp.qvw, Add a button to call sal.qvw with 'openQlikviewDocument' action.

This may help you.

Regards,

Charitha.