topic Re: hide/show the sheets in QlikView

hide/show the sheets

sonysree88 — Wed, 19 Apr 2017 13:16:41 GMT

I have sheets names in 1st page : 1st page is called main sheet:

like Main :

--sheet1

--sheet2

--sheet3

If i can open the report main sheet should open

if i can click on sheet1 on main page it will go to sheet1 vise versa..

Regards,

Sonysree

Re: hide/show the sheets

Wed, 19 Apr 2017 13:36:15 GMT

Hi Sonysree,

Please see below and qvw attached. Is this what you need?

Re: hide/show the sheets

sonysree88 — Wed, 19 Apr 2017 13:45:45 GMT

Can you please send me the detailed steps ..

I dont have the licensed edition am using personal edition i am unable to open the qvw which you shared it to me..

Re: hide/show the sheets

vinieme12 — Wed, 19 Apr 2017 14:02:53 GMT

To See only one sheet at a time, lets take for exampe you have 4 Sheets then

create 4 variables

example

vsheet1

vsheet2

vsheet3

vsheet4

Right Click on Sheet1 >> Properties >> Select Conditional Show <<enter variable>> = vsheet1

Repeat the above for each Sheet and add variable for respective sheet

Create a Button / Textbox to show Sheet2 >> Right Click >> Properties >> Actions >>

You need to set 4 Actions for each variable

Set External >> Set a Variable >>

enter variable name >> vsheet1

value = 0 //to hide sheet1

enter variable name >> vsheet2

value = 1 //to show sheet2

enter variable name >> vsheet3

value = 0 //to hide sheet3

enter variable name >> vsheet4

value = 0 //to hide sheet4

similarly

Create a Button / Textbox to show Sheet3 >> Right Click >> Properties >> Actions >>

You need to set 4 Actions for each variable

Set External >> Set a Variable >>

enter variable name >> vsheet1

value = 0 //to hide sheet1

enter variable name >> vsheet2

value = 0 //to hide sheet2

enter variable name >> vsheet3

value = 1 //to show sheet3

enter variable name >> vsheet4

value = 0 //to hide sheet4

and so on

Re: hide/show the sheets

sonysree88 — Thu, 20 Apr 2017 09:47:40 GMT

I have created like this but its nt working to me even its not going to other sheets from 1 sheet to another

i want to see 1 sheet at a time

in main page i have to create 3 textboxes like

sheet1

sheet2

sheet3

when i open the dashboard 1st main page only i want to see and after that based on selection sheets should display..

Can you please find the below

Re: hide/show the sheets

Thu, 20 Apr 2017 09:59:08 GMT

add action to ur textbox

rightlcick>properties>action>add>layout>activatesheet>shettid(its going be id of each sheet)

Re: hide/show the sheets

Thu, 20 Apr 2017 10:05:17 GMT

Hi, apologies for the delay. Here you go

Step 1 - locate sheet ID for sheet1 via sheet properties, screenshot below

Step 2 - go to Main sheet. Add Action to your text object via text object properties, see below

Step 3 - enter sheet ID for sheet1 as below. Repeat these steps for sheet2 & 3.

I hope this make sense. Let me know how you get on.

Warm regards,

Nish

Re: hide/show the sheets

vinieme12 — Thu, 20 Apr 2017 10:19:02 GMT

have you enabled Show Conditional in Sheet Properties?

the below step??

Right Click on Sheet1 >> Properties >> Select Conditional Show <<enter variable>> = vsheet1

Repeat the above for each Sheet and add variable for respective sheet

Re: hide/show the sheets

sonysree88 — Thu, 20 Apr 2017 13:17:09 GMT

Hi all,

am not expecting to go from one sheet to another sheet

when i click on main page here 3 sheets text boxes will be there

if i can click on sheet1 it should display to sheet1 vice versa

i am following your steps vineeth which you shared

Can you please find the attached QVW and provide me the solution in detailed steps..

Re: hide/show the sheets

Anonymous — Thu, 20 Apr 2017 13:32:01 GMT

Every thing is ok. Just uncheck the Show All Sheets and Objects in Document properties - Security tab.

Re: hide/show the sheets

sonysree88 — Thu, 20 Apr 2017 13:34:57 GMT

Thank you vineet and shiva nagesh

Its working fine