Displaying Sheet through Buttons

[vignesh_s]

hi have created a 5 sheet , need  to create a 4 button in the 1st sheet so that the i should able to toggle to any of the sheet from buttons

and sheet tab should to hide,is this possible in qlik can any1 hlp me out

[Anil_Babu_Samineni · Accepted solution]

Qlik can do anything..

We have actions for Sheet. Try to get Properties - Actions - There we can see "Activate sheet" etc..

[vignesh_s]

i wanna hide Sheet tabs how should i do tat,in image red marked one should b hide

[Anil_Babu_Samineni]

Go to Settings - Document Properties (Ctrl + Alt +D) - General - Hide Tabrow ??

[ruchirasamant]

Hi,

You can try this

In button add the Action

Action>> Active Sheet>> specify the sheet id that you need to show

also add the Set variable property

Action>>Set Variable>> give the variable

Now for your renaming 4 sheets go to Sheet Properties>> Show>> Conditional>> if((VSheet)=1,1,0)

Thanks,