topic How to hide a Sheet without conditional show in QlikView

How to hide a Sheet without conditional show

Wed, 05 Aug 2009 20:34:18 GMT

Hi,

I want to hide a sheet by wrting a macro.Please help me if anyboady implemented the solution for the same.

I created a button called as XXXX and once i qlik on this button,need to hide "YYYY" sheet.

thanks in advance.

Ram

blaise — Wed, 05 Aug 2009 20:57:05 GMT

Set a conditional show on the Sheet if a variable is set to 1, f.ex. if($(varSheetShow)=1,1,0)

Write a macro that sets the variable varSheetShow to 1.

Thu, 06 Aug 2009 21:22:03 GMT

Yes i already tried this.In this case how can paas the value to the conditional show.

Thu, 06 Aug 2009 21:22:11 GMT

Yes i already tried this.In this case how can paas the value to the conditional show.

Thu, 06 Aug 2009 21:23:02 GMT

I mean into $(varSheetShow)= through macro.Can u paste the sample script if you have

blaise — Thu, 06 Aug 2009 21:30:57 GMT

Sub dimShow

set var = ActiveDocument.Variables("dimShow")

var.SetContent 1,true

end sub