topic Re: Conditionally show/hide expression column based on the expanded or collapsed columns? in QlikView https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607632#M548305 <HTML><HEAD></HEAD><BODY><P>You are talking about a pivot table?</P><P></P><P>I don't think so.</P><P></P><P>You can use a condition in your expression using Dimensionality() / SecondaryDimensionality() to execute different code per dimension level (when using partial sums).</P></BODY></HTML> Tue, 04 Feb 2014 20:40:32 GMT swuehl 2014-02-04T20:40:32Z Conditionally show/hide expression column based on the expanded or collapsed columns? https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607630#M548303 <HTML><HEAD></HEAD><BODY><P>Is it possible to conditionally show/hide an expression column based on what dimension columns are expanded or collapsed?</P></BODY></HTML> Tue, 04 Feb 2014 20:31:49 GMT https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607630#M548303 2014-02-04T20:31:49Z Re: Conditionally show/hide expression column based on the expanded or collapsed columns? https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607631#M548304 <HTML><HEAD></HEAD><BODY><P>You should try the dimensionality() function. Read details in the QV help</P><P></P><P>Ex. Dimensionality() returns 2 if 2 dimensions are expanded in the pivot.</P><P>Grand Total has dimensionality() =0</P><P></P><P>Michael</P></BODY></HTML> Tue, 04 Feb 2014 20:38:24 GMT https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607631#M548304 agilos_mla 2014-02-04T20:38:24Z Re: Conditionally show/hide expression column based on the expanded or collapsed columns? https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607632#M548305 <HTML><HEAD></HEAD><BODY><P>You are talking about a pivot table?</P><P></P><P>I don't think so.</P><P></P><P>You can use a condition in your expression using Dimensionality() / SecondaryDimensionality() to execute different code per dimension level (when using partial sums).</P></BODY></HTML> Tue, 04 Feb 2014 20:40:32 GMT https://community.qlik.com/t5/QlikView/Conditionally-show-hide-expression-column-based-on-the-expanded/m-p/607632#M548305 swuehl 2014-02-04T20:40:32Z