topic Hide Sheets Issue in QlikView

Hide Sheets Issue

Wed, 18 Nov 2009 20:26:29 GMT

Hi,

I have written below macro code to hide sheets, however it is only hiding sheets but not showing it.

Code

sub

showObjectA

set

p=ActiveDocument.Variables("pShowObject"

)

true

end

sub

showObjectB

set

p=ActiveDocument.Variables("pShowObject"

)

true

end

sub

showObjectC

set

p=ActiveDocument.Variables("pShowObject"

)

true

end

sub

/Code

Please let me know wht I need to add it in the code to show the sheets as well.

Thanks,

Sunil

Hide Sheets Issue

shumailh — Wed, 18 Nov 2009 20:48:12 GMT

Hi sunil,

I was also looking for the same query.

Regards,

Hide Sheets Issue

Wed, 18 Nov 2009 21:15:24 GMT

i can't decypher your macro code

could you please send a correctly indented version ?

Hide Sheets Issue

prieper — Wed, 18 Nov 2009 21:20:21 GMT

Find it in most cases more useful to link the "Show"-functionality (Object or Sheet) to a variable and then change the setting of the variable (by inputbox, macro, user-access etc).

HTH
Peter

Hide Sheets Issue

Wed, 18 Nov 2009 22:39:05 GMT

I have already done 'Show condition', it is able to hide, but not able to show the sheet on selection.

Hide Sheets Issue

prieper — Wed, 18 Nov 2009 23:04:44 GMT

Hi,
try something like the attached

HTH
Peter