topic Re: Existing sheet is hiding when add new sheet in QlikView

Existing sheet is hiding when add new sheet

qlikviewwizard — Wed, 25 Mar 2015 06:32:37 GMT

Hi All,

Existing sheet is hiding when add new sheet. Please help.

Thanks in advance.

Re: Existing sheet is hiding when add new sheet

sagarkharpude — Wed, 25 Mar 2015 06:37:58 GMT

elaborate please what you want to say.

Re: Existing sheet is hiding when add new sheet

Wed, 25 Mar 2015 06:42:53 GMT

Go to Document properties > sheet & find previous sheet exist or not..

Re: Existing sheet is hiding when add new sheet

Anonymous — Wed, 25 Mar 2015 06:47:57 GMT

Can you share sample Qvw

Re: Existing sheet is hiding when add new sheet

qlikviewwizard — Wed, 25 Mar 2015 06:51:48 GMT

Previous sheets or showing in a drop down box. If I want to work with new sheet, need to select from the drop down list.

Re: Existing sheet is hiding when add new sheet

Wed, 25 Mar 2015 07:05:30 GMT

Hi,

Its better to share your screen-shot if you can will be more helpful..

Re: Existing sheet is hiding when add new sheet

Wed, 25 Mar 2015 07:11:13 GMT

Please check these images for your answer

STEP 1 :

Here is your file dialog box

STEP 2:

Check the marked place it shows you ADD/Remove Buttons and sub buttons Design/Customize. Click Customize Now

STEP 3 :

NOW APPEARS AN DIALOG BOX AS CUSTOMIZE .Select Sheets CheckBox in Dialog Box.

And Close The Dialog Box.It Appears a Tab on the sheet check your hidden sheets there.

Regards

Naveen

Re: Existing sheet is hiding when add new sheet

giakoum — Wed, 25 Mar 2015 07:13:33 GMT

uncheck if checked

Re: Existing sheet is hiding when add new sheet

sagarkharpude — Wed, 25 Mar 2015 07:20:20 GMT

PFA.

Select the car model , it will go to other sheet and current sheet will be hide.

Re: Existing sheet is hiding when add new sheet

Wed, 25 Mar 2015 07:32:44 GMT

Try this

Show and Hide Tabs - YouTube

Go to Settings---> select DOCUMENT PROPERTIES---> go to GENERAL TAB. Check The Hide TABROW is Unchecked Or checked in the PROPERTIES.

You can hide sheets by going to sheet properties and then General tab --> Now you can select Conditional under Show Sheet --> Here you can put an expression that to show or hide the sheet if expression value is true then it will show sheet else hide.

We can also derive expression based on variable value and this can be accessed using command button or any other event.

Regards,

Naveen

Re: Existing sheet is hiding when add new sheet

Peter_Cammaert — Wed, 25 Mar 2015 07:51:59 GMT

Open the Properties of each sheet. On the General tab you will discover an expression in the Conditional Show field.

The Main sheet will be visible only when no selections are made (variable vSelection = 0)
The Details sheet will be visible whenever a single value in field Car has been selected (variable vSelection = 1).

Who now is detecting selections made in field Car, and changing the value of variable vSelection, you may ask...

Open Settings->Document Properties->Triggers.

In the Field Event Triggers list, you will see a <has actions> indicator next to the Car field. If you select Car from this list, the OnSelect->Add Action(s) button changes to Edit Action(s), meaning that on every select in field Car, a trigger will be fired and the associated actions will be executed.

Click the button to see what actions are executed. There you'll find out who does what with vSelection.

Best,

Peter