Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Pivot Table collapsed/expanded indicator?

Is there a way to indicate whether a dimension is expanded or collapsed in a Pivot Table? Can it be used in another dimension, or only in an expression?

5 Replies
srikanthsri1
Valued Contributor

Re: Pivot Table collapsed/expanded indicator?

yes,in pivot table , in the presentation tab select allow pivoting and unselect the option always expanding

Partner
Partner

Re: Pivot Table collapsed/expanded indicator?

I didn't mean a visual indicator, I meant something that can return a true or false value.

Highlighted
chematos
Valued Contributor II

Re: Pivot Table collapsed/expanded indicator?

Dimensionality() function returns the number of dimensions expanded, I think you could use it to get near to your purpose

Partner
Partner

Re: Pivot Table collapsed/expanded indicator?

Dimensionality won't work in a dimension, only in an expression. It also won't tell you which field was collapsed.

chematos
Valued Contributor II

Re: Pivot Table collapsed/expanded indicator?

Sorry, I didn´t undesrtand your question.

I don´t know how to make that, but I supose you need to get the properties of the object where the dimension is and may be with GetObjectField() you could get something but I don´t really know if is possible to do it .....

Good luck