topic Re: Displaying Sheet through Buttons in QlikView

Displaying Sheet through Buttons

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 18 Dec 2017 06:44:16 GMT

Qlik can do anything..

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

vignesh_s — Mon, 18 Dec 2017 06:51:13 GMT

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

Anil_Babu_Samineni — Mon, 18 Dec 2017 06:52:53 GMT

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

ruchirasamant — Mon, 18 Dec 2017 06:55:04 GMT

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,