Hiding Tab Sheets using text objects as buttons

Tue, 15 Jul 2014 15:42:41 GMT

I've been trying to get this to work for days now and am running out of patience. I downloaded the DynamicPages.qvw file and I thought I understood how it all works -- it does exactly what I want, which is to provide a set of buttons to hide or show one or more tab sheets in my document.

I created a series of text objects which set a variable called vSheetGroup. Each button sets a variable letter from A to G.

I created the CROSSTABLE just as the example does passing a SheetName and SheetAllowed variables as well as the OSUser, then initialize the table with a LOAD * INLINE which appears to be working, I can see all the values being set correctly.

Each tab page then has a condition variable set which uses the SheetName and the OSUser to hide or show the sheet:

=sum({<SheetName={'Sheet 6'},OSUser={'$(vOSUser)'}>}if(index(vSheetGroup,'B') > 0,SheetAllowed, 0)) > 0

The only difference is I use different sheet names, but they are all just strings. Each page has an index value of A thru G, selecting Show All sets the vSheetGroup to ABCDEFG. The Sheet Security buttons set the variable vSheetSecurity to either 1 for on or 0 for off.

Lastly I defined a variable OSUser as

=if(vSheetSecurity = 1, OSUser(), '*')

But regardless of all this, clicking the buttons on my menu page does nothing (other than set the value of the vSheetGroup variable, which I can see in the Variable Overview)

I must be missing something. I have all the same variables and condition variables, the only differences are the names of the sheets. How can I figure out what is going wrong? I also tried removing the OSUser column since I don't really need it but that made no difference

Thanks for any suggestions.

Gary

topic Hiding Tab Sheets using text objects as buttons in QlikView

Hiding Tab Sheets using text objects as buttons