topic Re: How to show multiple sheets one sheet each time? in QlikView

How to show multiple sheets one sheet each time?

qlikviewwizard — Mon, 30 Mar 2015 03:47:05 GMT

I have 4 sheets consequently as Sheet1,Sheet2,Sheet3,sheet4.

How to show them one sheet each time?

Re: How to show multiple sheets one sheet each time?

arulsettu — Mon, 30 Mar 2015 03:56:51 GMT

can you explain more?

Re: How to show multiple sheets one sheet each time?

sushil353 — Mon, 30 Mar 2015 04:45:31 GMT

Hi,

You can use button on each sheet to activate the desired sheet from the current active sheet.

HTH

Sushil

Re: How to show multiple sheets one sheet each time?

qlikviewwizard — Mon, 30 Mar 2015 06:20:13 GMT

If I want to see Sheet1, need to see only Sheet1

If I want to see Sheet2, need to see only Sheet2

If I want to see Sheet1 and Sheet2, need to see only and Sheet1 and Sheet2 together.

Re: How to show multiple sheets one sheet each time?

maxgro — Mon, 30 Mar 2015 06:26:17 GMT

use button to hide/show tabrow

in menù --> document properties --> general --> check hide tabrow

Re: How to show multiple sheets one sheet each time?

Mon, 30 Mar 2015 06:40:12 GMT

HIII

justr see this image below for your reference

when you check hide the tabrow button in the sheets it activates shows your sheets in a single sheet.

Re: How to show multiple sheets one sheet each time?

sandeepprasad_j — Mon, 30 Mar 2015 06:53:44 GMT

Hello ,

Please refer to the below

Need All sheets to be displayed upon selections???

HELP In Designing

Designing Help???

Hope it helps

Thanks,

Sandeep.

Re: How to show multiple sheets one sheet each time?

ashfaq_haseeb — Mon, 30 Mar 2015 07:00:36 GMT

Hi,

Check this

http://community.qlik.com/message/535022#535022

Regards

ASHFAQ

Re: How to show multiple sheets one sheet each time?

Mon, 30 Mar 2015 07:24:02 GMT

Hi,

You can create 4 text objects. Try like this. I hope it is helps to you.

Re: How to show multiple sheets one sheet each time?

qlikviewwizard — Mon, 30 Mar 2015 07:28:14 GMT

Hi Anyone could help me out please.I enclosed the file.

Thanks in advance.

Re: How to show multiple sheets one sheet each time?

Mon, 30 Mar 2015 07:31:31 GMT

HI,

it is simple way to do this in three steps

1) First create four buttons for each sheet in in each button with action activate sheet.

2) In Document properties -> General -> clicking on Hide tabrow.

3) after hide tabrow it will show only one main sheet which you created buttons for sheets and by clicking on each button it will display your sheets.

Re: How to show multiple sheets one sheet each time?

ashfaq_haseeb — Mon, 30 Mar 2015 07:36:01 GMT

Check this.

Regards

ASHFAQ

Re: How to show multiple sheets one sheet each time?

avinashelite — Mon, 30 Mar 2015 07:58:33 GMT

Hi,

Please use the button and variable to achieve this.

steps:

1.Create a variable with value 0.

2.Create a button , then use the button action properties to set the variable for 0 or 1.

3.Go to sheet properties and use the conditional show option to hide and show