topic Re: Sheet Hide and Show in QlikView

Sheet Hide and Show

Nagaraju_KCS — Sat, 19 Oct 2013 05:43:25 GMT

Hi Community,

I have 2 sheets(Sheet1 and Sheet2) in that two buttons Button1 and Button2.in each sheet

when i am open my application i want to show Sheet1, when am click Button2 i want to show Sheet2 and

when i am click Button1 i want to show Sheet1

Re: Sheet Hide and Show

VishalWaghole — Sat, 19 Oct 2013 06:44:18 GMT

PFA hope so that will help u.......

Thanks and Regards,

Vishal Waghole

Re: Sheet Hide and Show

Sat, 19 Oct 2013 07:16:53 GMT

You can try this,

Create a button in each sheet. let it be button1 and button2.

Create a variable vShowSheet and set its value to 1. Now for sheet1 go to properties>>general>>conditional show. give expression =$(ShowSheet)=1. and for sheet2 set the property as =$(ShowSheet)=2.

Now for button1 set action in external action>>set variable and in variable name give ShowSheet and in value, give expression as =if($(ShowSheet)=1,2,1). and for button2 in sheet 2 give variable name in external event as ShowSheet and value as =if($(ShowSheet)=2,1,2).

Hope this works.

Re: Sheet Hide and Show

CELAMBARASAN — Sat, 19 Oct 2013 16:11:43 GMT

check the attached.

I have just checked the hide tab row in document properties.