Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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


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.



4 Replies
MVP & Luminary
MVP & Luminary

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


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

Not applicable

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


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