topic Re: Pivot Table collapsed/expanded indicator? in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362971#M134943 <HTML><HEAD></HEAD><BODY><P>Sorry, I didn´t undesrtand your question.</P><P>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 .....</P><P></P><P>Good luck</P></BODY></HTML> Thu, 21 Jun 2012 15:59:43 GMT chematos 2012-06-21T15:59:43Z Pivot Table collapsed/expanded indicator? https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362966#M134938 <HTML><HEAD></HEAD><BODY><P>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?</P></BODY></HTML> Thu, 21 Jun 2012 14:40:05 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362966#M134938 danielact 2012-06-21T14:40:05Z Re: Pivot Table collapsed/expanded indicator? https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362967#M134939 <HTML><HEAD></HEAD><BODY><P>yes,in pivot table , in the presentation tab select allow pivoting and unselect the option always expanding</P></BODY></HTML> Thu, 21 Jun 2012 14:44:14 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362967#M134939 Anonymous 2012-06-21T14:44:14Z Re: Pivot Table collapsed/expanded indicator? https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362968#M134940 <HTML><HEAD></HEAD><BODY><P>I didn't mean a visual indicator, I meant something that can return a true or false value.</P></BODY></HTML> Thu, 21 Jun 2012 14:45:25 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362968#M134940 danielact 2012-06-21T14:45:25Z Re: Pivot Table collapsed/expanded indicator? https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362969#M134941 <HTML><HEAD></HEAD><BODY><P>Dimensionality() function returns the number of dimensions expanded, I think you could use it to get near to your purpose</P></BODY></HTML> Thu, 21 Jun 2012 15:53:23 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362969#M134941 chematos 2012-06-21T15:53:23Z Re: Pivot Table collapsed/expanded indicator? https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362970#M134942 <HTML><HEAD></HEAD><BODY><P>Dimensionality won't work in a dimension, only in an expression. It also won't tell you which field was collapsed.</P></BODY></HTML> Thu, 21 Jun 2012 15:54:55 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362970#M134942 danielact 2012-06-21T15:54:55Z Re: Pivot Table collapsed/expanded indicator? https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362971#M134943 <HTML><HEAD></HEAD><BODY><P>Sorry, I didn´t undesrtand your question.</P><P>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 .....</P><P></P><P>Good luck</P></BODY></HTML> Thu, 21 Jun 2012 15:59:43 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-collapsed-expanded-indicator/m-p/362971#M134943 chematos 2012-06-21T15:59:43Z