Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

kunkumnaveen
Contributor III

how to hide and show sheet tab

HI

suppose if i got two sheets,sheet1,sheet2

  on sheet1 i got 26 text box each text box as activate to sheet2 trigger on

so my requirement is when i open the application only sheet1 as to be visible ,later if i click on any of the text box (26),then  sheet2 should appear ,and after pressing clear all button it should disappear....

so literally i need hide and show sheet tab

1 Solution

Accepted Solutions
amit_saini
Honored Contributor III

Re: how to hide and show sheet tab

Hi,

PFA,

Thanks,

AS

5 Replies
sureshqv
Esteemed Contributor III

Re: how to hide and show sheet tab

define a button with Action external "set variable" (e.g. vsheet1 and Expression

"if (vsheet=1,0,1)

now define in sheet properties condittional  (vsheet1=1= adn you can toggle with your button (donot plaqce the button on the sheet you want to hide!)

sureshqv
Esteemed Contributor III

Re: how to hide and show sheet tab

abd then give  trigger to last text box  or  sheet on leave trigger  so it will gives u

Re: how to hide and show sheet tab

You can use conditional hide/show option on the General tab of sheet properties

Capture.PNG

amit_saini
Honored Contributor III

Re: how to hide and show sheet tab

Hi,

PFA,

Thanks,

AS

Re: how to hide and show sheet tab

1) Create one variable on front end as vShow.

2) On sheet 1 go to properties of text object -> Action -> add -> External -> Set variable -> vShow ->value=1.

    Like wise you set the variable value for each 26 text object. So for 26th text object vShow value should be 26

3) Go to Setting-> Document Properties-> Triggers-> OnOpen -> add External -> Set Variable -> vShow ->value=0

    Now go to sheet 2 properties ->general tab ->conditional ->Put below condition

    =match('$(vShow)','1','2','3',......'26')

 

Community Browser