topic Re: Leaving a Sheet Event in QlikView

Leaving a Sheet Event

manpri7078 — Wed, 13 Nov 2013 05:48:02 GMT

Hi all,

I have a one very basic query. Suppose Sheet 2 is activated. When I activate Sheet 1, Sheet 2 should be hidden. On Sheet 2's properties what conditional expression should I write for Show, to achieve this. This should be very simple, but I am simply not able to do that.

Regards,

Manish Prasad

Re: Leaving a Sheet Event

kaushiknsolanki — Wed, 13 Nov 2013 06:00:32 GMT

Hi,

Do one thing, Create a Variable say vShoqHide

Give default value as 1.

Now create a button on both the sheets,

on sheet1's Button, add action to set the variable value to 2.

and go to sheet properties -> General -> Show Sheet -> Conditional

Add expression as =if(vShowHide = 1,1,0)

Now on sheet2's Button, add action to set the variable value to 1.

and go to sheet properties -> General -> Show Sheet -> Conditional

Add expression as =if(vShowHide = 2,1,0)

For more clarification have a look at the attached example

Regards,

Kaushik Solanki

Re: Leaving a Sheet Event

nivethitha — Wed, 13 Nov 2013 08:06:31 GMT

Hi,

There is also an another way,

create an inline table in edit script

Load * inline [

No, SheetID

1,SH01

2,SH02

];

No is just to denote, and Sheetid is the respective id of sheet1 and sheet2.

now create a list box in both in sheets with the field 'No'

In Sheet1, give the condition as No=1

In sheet2, give the condition as No=2

U will get the expected result when the value 1 or 2 is clicked from the list box.

Regards,

Nivethitha

Re: Leaving a Sheet Event

manpri7078 — Wed, 13 Nov 2013 09:24:28 GMT

Hi,

I agree with what you are saying or what Kaushik was also suggesting. I am clarifying my query a little bit more. In my document I have one sheet (SH01). In that sheet there is one clickable object which activates another sheet, say SH02 for in depth analysis. Now I wants that when I leaves that sheet (SH02) and returns to SH01, that sheet (SH02) gets hidden, until I again click on the clickable object in SH01, which should be permanently shown. Sheet SH02 will be displayed only when required if I click the clickable object on Sheet SH01 and not otherwise.

I hope I am able to put my query more clear now. Is this possible and if yes, how ?

Regards,

Manish Prasad

Re: Re: Leaving a Sheet Event

Wed, 13 Nov 2013 09:35:37 GMT

HI manish,

check the attached one.

Regards

Kumar

Re: Leaving a Sheet Event

manpri7078 — Wed, 13 Nov 2013 09:56:50 GMT

Dear Ravi,

Thanks a lot for your reply. It solved my problem and now I have been able to accomplish what I wants.

Regards,

Manish Prasad

Re: Leaving a Sheet Event

rajni_batra — Wed, 13 Nov 2013 10:40:13 GMT

Hi manish,

If ur issue has been resolved then plz mark Ravi's answer as correct answer and close the thread.

Regards,

Rajni

Re: Leaving a Sheet Event

Wed, 29 Jan 2014 10:27:33 GMT

nice nivi