topic Re: Show and hide sheets in QlikView

Show and hide sheets

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

Hi All,

I have 3 sheets with Sheet1,Sheet2,Sheet3.

My requirement is Sheet1 is always should be active.

remaining should be shown based on selection.

If Sheet2 is active, sheet3 should be hidden.

If Sheet3 is active, sheet2 should be hidden.

Please advise.

Re: Show and hide sheets

Frank_Hartmann — Wed, 02 Nov 2016 15:21:05 GMT

see attached file.

hope this helps!

Re: Show and hide sheets

arethaking — Thu, 03 Nov 2016 01:22:59 GMT

Hi franky_h79

By default I want to show Sheet1.

Sheet2 to Sheet3 is not working.

Please help.

Re: Show and hide sheets

arethaking — Thu, 03 Nov 2016 02:53:51 GMT

I am trying with this but unable to fix it.

Re: Show and hide sheets

vardhancse — Thu, 03 Nov 2016 03:56:49 GMT

Hi,

1. Create on open trigger to open sheet 1 by default.

2. In sheet1->text object->Action->to open sheet2

3. In sheet2->text object->Action->to open sheet2

4. Settings->Documents Properties->Hide Tab Row

PFA attached QVW

Re: Show and hide sheets

arethaking — Thu, 03 Nov 2016 07:01:38 GMT

Hi vardhancse

Thank you for the solution. I want to show always first sheet. How to show?

Re: Show and hide sheets

jyothish8807 — Thu, 03 Nov 2016 07:31:49 GMT

Hi Aretha,

Is this what you are looking for?

Br,

Re: Show and hide sheets

Frank_Hartmann — Thu, 03 Nov 2016 07:34:40 GMT

As far as I understood your requirement when opening the app all the sheets should be displayed. When I open sheet 2, sheet1 remains and sheet 3 disappears. When I openon sheet 3, sheet1 remains and sheet 2 disappears.

So this is not your requirement?

then please describe your requirement in more detail, because my sample shows exactly what you were asking above.

Re: Show and hide sheets

vardhancse — Thu, 03 Nov 2016 07:37:29 GMT

HI.

1. Create on open trigger to open sheet 1 by default.

settings->documents & Settings->Triggers->On Open->Add Action

Add->Layout->Activate sheet->SH01

SH01= [Sheet ID]

Re: Show and hide sheets

Thu, 03 Nov 2016 07:39:53 GMT

Hi,

I will give you a basic and easy idea to solve this.

1. Create three sheets SHEET1, SHEET2 and SHEET3. Declare a variable vDisplay

2. Create two buttons SHEET2 and SHEET3 in the SHEET1

3. Go to SHEET2(Button Properties) >>> Action >>> External >>> Set Variable >>> vDisplay >>> Value=0

4. Go to SHEET3(Button Properties) >>> Action >>> External >>> Set Variable >>> vDisplay >>> Value=1

4. Go to Sheet Properties of Sheet2 and in Show Sheet tab give the Condition as vDisplay=0

5. Go to Sheet Properties of Sheet3 and in Show Sheet tab give the Condition as vDisplay=1

Your requirement has been met. Kindly notify for further clarification.

Re: Show and hide sheets

punitpopli — Thu, 03 Nov 2016 07:41:04 GMT

You can save the QVW on sheet 1 or can apply Activate sheet on OnOpen trigger followed by the sheet ID

Re: Show and hide sheets

Anonymous — Thu, 03 Nov 2016 08:54:43 GMT

Hi,

Check out this ..

Re: Show and hide sheets

arethaking — Thu, 03 Nov 2016 09:44:30 GMT

Hi Frank Hartmann and Sasi V Kandragula

When Sheet1 is open, Sheet2 and Sheet3 should be hidden.

When Sheet2 is open, Sheet1 should be open and Sheet3 should be hidden.

When Sheet3 is open, Sheet1 should be open and Sheet2 should be hidden.

Re: Show and hide sheets

Frank_Hartmann — Thu, 03 Nov 2016 09:56:55 GMT

like this?

Re: Show and hide sheets

jyothish8807 — Thu, 03 Nov 2016 10:04:03 GMT

Try this:

Re: Show and hide sheets

vardhancse — Thu, 03 Nov 2016 10:04:57 GMT

Hi,

As per your requirement done the changes.

we can use Variables

Re: Show and hide sheets

beck_bakytbek — Thu, 03 Nov 2016 12:47:37 GMT

Hi Aretha,

check this: Qlikview Tips & Tricks: How to make hidden tab-row dynamically? - YouTube

i hope that helps

beck