topic Re: conditional hide is not working in QlikView

conditional hide is not working

Thu, 13 Nov 2014 12:56:38 GMT

In sheet properties,I used conditional as zero.

But its not working.Is any setting required for hiding sheet.

Regards,

Amol

Re: conditional hide is not working

Thu, 13 Nov 2014 13:00:21 GMT

it should work

what condition u made can u post it here

example:

product =apple then only u want see that chart means write like this

if(product='apple',1,0) here if condition true it shows other wise it hide

pls change the expression as per ur requirment

write the condition in layout tab

Re: conditional hide is not working

agomes1971 — Thu, 13 Nov 2014 13:02:25 GMT

Hi,

strange...

Easiest way to hide and show the sheet.

Hide Sheet:

Sheet Properties > Tab General > Select Radio Box "Conditional" set value 0 > Apply > OK.

Show Sheet:

Settings > Document Properties > Tab Sheets > Select "Sheet" > Properties > General > Select Radio Box Always > Apply > OK.

Can you please post a sample of your qvw...

Regards

André Gomes

Re: conditional hide is not working

mato32188 — Thu, 13 Nov 2014 13:02:57 GMT

Ctrl+Alt+D

Security

Make sure, you have unchecked Show All Sheets and Objects

Martin

Re: conditional hide is not working

jonathandienst — Thu, 13 Nov 2014 13:06:32 GMT

Are you sure you don't have 'Show All' mode set (which causes QV to ignore the conditional show/hide)? Press Ctrl-Shift-S to toggle between normal mode and 'Show All' mode.

HTH

Jonathan

Edit - or CTRL-ALT-D | Security | Show all sheets and objects (as suggested above)