topic Re: SHEETS HIDE AND SHOW in QlikView

SHEETS HIDE AND SHOW

Thu, 29 Oct 2015 17:46:57 GMT

I have 3 Sheets labeled Sheet1, Sheet2 and Sheet 3. ON Each Sheet I have 3 buttons, each button is Called as

Sheet1, Sheet2 and Sheet 3. SO when I click on Sheet1, it shows only Sheet1 and hide the other sheets, or if I select Sheet2, it shows, Sheet 2 only and Hide the others. How can I do that

Re: SHEETS HIDE AND SHOW

mayankraoka — Thu, 29 Oct 2015 17:50:50 GMT

Hi ,

You can go on action and select activate sheet (add-action type -layout)and give the sheet id number over there..

Regards,

Mayank

Re: SHEETS HIDE AND SHOW

miguelbraga — Thu, 29 Oct 2015 17:56:18 GMT

Hi Rehan,

Make 3 variables (vTab1, vTab2, vTab3) and in the Sheet Properties check the Conditional and add this expression:

For Sheet 1:

=vTab1='Yes'

For Sheet 2:

=vTab2='Yes'

For Sheet 3:

=vTab3='Yes'

Button 1:

Set Variable

Variable>vTab1;

Value>=if(vTab1='Yes', 'No', 'Yes')

Variable>vTab2

Value> =if(vTab1='Yes', 'No', 'Yes')

Variable>vTab3

Value> =if(vTab1='Yes', 'No', 'Yes')

Button 2:

Set Variable

Variable>vTab2;

Value>=if(vTab2='Yes', 'No', 'Yes')

Variable>vTab1

Value> =if(vTab2='Yes', 'No', 'Yes')

Variable>vTab3

Value> =if(vTab2='Yes', 'No', 'Yes')

Button 3:

Set Variable

Variable>vTab3;

Value>=if(vTab3='Yes', 'No', 'Yes')

Variable>vTab2

Value> =if(vTab3='Yes', 'No', 'Yes')

Variable>vTab1

Value> =if(vTab3='Yes', 'No', 'Yes')

This can and should do the trick

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 18:04:00 GMT

Take a variable vbutton.

For Sheet1 - Go to sheet properties- general - conditional enabling - vButton =1.

For button sheet1 - use an action - external - setvariable - (variable - vbutton and value = 1)

For Sheet2 - Go to sheet properties- general - conditional enabling - vButton =2

For button sheet2 - use an action - external - setvariable - (variable - vbutton and value = 2)

For Sheet3 - Go to sheet properties- general - conditional enabling - vButton =3.

For button sheet3 - use an action - external - setvariable - (variable - vbutton and value = 3)

This should work. It is working fine to me

Regards,

Varun

Re: SHEETS HIDE AND SHOW

Thu, 29 Oct 2015 18:10:17 GMT

It didnt work, it HIDES ALL THE SHEET AS u click on each button

Re: SHEETS HIDE AND SHOW

Thu, 29 Oct 2015 18:15:25 GMT

It didnt work for me, can you please attach a qvw?

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 18:21:12 GMT

Re: SHEETS HIDE AND SHOW

Thu, 29 Oct 2015 18:23:20 GMT

Pls attach a qvw , I did the same thing

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 18:25:51 GMT

Can you guide me how to insert QVW?

I dont see any option. I will post it

Re: SHEETS HIDE AND SHOW

mayankraoka — Thu, 29 Oct 2015 18:34:00 GMT

Hi Varun,

May be you are having personal edition.

Regards,

Mayank

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 18:39:12 GMT

Right click on tabrow, you will find the image 1 option.

If you select button object, you will find the second screen shot

Re: SHEETS HIDE AND SHOW

prabhu0505 — Thu, 29 Oct 2015 18:39:36 GMT

Attached simple example.

Re: SHEETS HIDE AND SHOW

mayankraoka — Thu, 29 Oct 2015 18:39:38 GMT

Rehan,

This link might help you:

How to show multiple sheets one sheet each time?

Regards,

Mayank

Re: SHEETS HIDE AND SHOW

Thu, 29 Oct 2015 18:54:43 GMT

NO its not a PErsonal Edition

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 18:57:38 GMT

I did it on personal edition.Can you tell me how you are doing?

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 19:11:12 GMT

Activating Sheets example

Re: SHEETS HIDE AND SHOW

Thu, 29 Oct 2015 19:53:56 GMT

This works great, but here is another problem, I have another sheet which is always there . So when I toggle the buttons, it always activates the First Sheet even though i have the selected sheet as a second sheet, since 1st sheet is alkways there

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 20:02:25 GMT

Use trigger on open

Go to document properties - Triggers - OnOpen - AddActions - Setvariable - vbutton =1

Re: SHEETS HIDE AND SHOW

varunreddy — Thu, 29 Oct 2015 20:03:53 GMT

When you open, it will always to go first sheet. If this is the answer, mention this as an answered.

This might help

Cheers!