How to show text box on opening of pivot table else hide.

[#1]

Hi,

Please let me know anyone how can i show or hide respectively on opening and closing the pivot table on click on the same pivot table not using any button.

Thanks,

Vasudha

[marcus_sommer]

It's only with macros possible to query an object-status like IsActive or IsMaximized. Especially the triggering from such actions are difficult and not recommended http://community.qlik.com/blogs/qlikviewdesignblog/2014/04/28/macros-are-bad. Therefore check the approach with a button-control again.

- Marcus

[alexandros17]

You could use the header of the pivot as a text box, infact you can control the pivot expand or collapse with dimensionality() function and according to its value you can show or hide text in the caption.

Hope this helps

[#4]

How can i use dimensionality() can u pls explain it with example..

[alexandros17]

Read the function in help, then try to add a new expression like this: dimensionality().

Now you can see that according with the level of pivot table the number change.

At this point, in the caption of the pivot you can write something like:

If(dimensionality()=1, 'This is the first level',

if(dimensionality() > 1, 'What are you doing here?', 'Bye bye'

)

)

Hope it helps