Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In sheet properties,I used conditional as zero.
But its not working.Is any setting required for hiding sheet.
Regards,
Amol
Hi
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)
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
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
Ctrl+Alt+D
Security
Make sure, you have unchecked Show All Sheets and Objects
BR
Martin
Hi
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)