Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

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
Master III
Master III

5 Replies
Chanty4u
MVP
MVP

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!)

Chanty4u
MVP
MVP

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

sunny_talwar

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

Capture.PNG

amit_saini
Master III
Master III

Hi,

PFA,

Thanks,

AS

Kushal_Chawda

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')