Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

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

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

4 Replies
MVP & Luminary
MVP & Luminary

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

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

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

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

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

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

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

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