topic Re: How to show a sheet show conditionally? in QlikView

How to show a sheet show conditionally?

ananyaghosh — Thu, 23 Apr 2015 12:00:52 GMT

Hi,

I need to show a sheet when I click on a button and the intended sheet is primarily will be hidden. So when I will click the button the sheet will be displayed.

Thanks,

Sandip

Re: How to show a sheet show conditionally?

Thu, 23 Apr 2015 12:05:33 GMT

PFA

Re: How to show a sheet show conditionally?

ananyaghosh — Thu, 23 Apr 2015 12:20:32 GMT

I am using personal edition. Can u give me some proper screen shot for that?

Thanks,

Sandip

Re: How to show a sheet show conditionally?

Gabriel — Thu, 23 Apr 2015 12:30:03 GMT

Hi,

Create a variable called vShowHide from variable overview window give it value of 0. Then create a button right click and go to properties click Add Action Type click External in the Action section to right click Set Variable click OK. Then in the Variable enter vShowHide in the value you will have to enter if statement as possibly this

if(vShowHide = 0,1,0)

Then in the object that you want to hide when you click on the button, right click on it and go to Layout then Show click Conditional then enter

vShowHide =0 .

Finally just click the button.

Re: How to show a sheet show conditionally?

satishkurra — Thu, 23 Apr 2015 12:30:31 GMT

Settings, Variable Overview - Create new variable as vShowHide and Value to 0

In Main Sheet, create a button with Action , Action type as Set Variable and Action as vShowHide=0

Create New Sheet as Sheet1 and in Sheet Properties general tab, Select Show sheet as COnditional and Specify as vShowHide=1.

No come to Main sheet and Click the button, You will see the difference.

Thanks

Satish

Re: How to show a sheet show conditionally?

Thu, 23 Apr 2015 12:31:58 GMT

Hi Sandip,

You can either set a condition on the sheet to show/hide, set to a variable value.

And have your button adjust the variable your condition is running from to show/hide on the button click.

Or if you are hiding the tabrow and trying to navigate between sheets with buttons seamlessly, then you don't need a condition, just simply a button with the activate sheet action to load the relevant sheet.

hope that helps

Joe

Re: How to show a sheet show conditionally?

Anonymous — Thu, 23 Apr 2015 12:36:20 GMT

HI,

You have to create à variable, for exemple : vSheet=0

Then you create a button with an action that change your variable vSheet with the fonction: if(vSheet=1,0,1)

Then you will be able to show or hide the sheet with a clik on this button

In the properties of the sheet to hide, you add a condition: vSheet=1: