topic Re: Expanded dimension in QlikView https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516640#M550342 <HTML><HEAD></HEAD><BODY><P>In point of fact I want to resolve this problem <A href="https://community.qlik.com/thread/100410">Hide row in pivot table</A>, so I'm trying different ways. </P></BODY></HTML> Mon, 02 Dec 2013 20:54:11 GMT nboccassini 2013-12-02T20:54:11Z Expanded dimension https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516635#M550337 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>is there a way to know if a dimension is expanded or not in a pivot table with 2 or more dimensions (indent style)?</P></BODY></HTML> Mon, 02 Dec 2013 17:07:53 GMT https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516635#M550337 nboccassini 2013-12-02T17:07:53Z Re: Expanded dimension https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516636#M550338 <HTML><HEAD></HEAD><BODY><P><STRONG>Gabriele</STRONG></P><P></P><P>Personally I find the + &amp; - signs, top right of the dimension value, more than sufficient.</P><P></P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill Markham</STRONG></P></BODY></HTML> Mon, 02 Dec 2013 17:51:38 GMT https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516636#M550338 Anonymous 2013-12-02T17:51:38Z Re: Expanded dimension https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516637#M550339 <HTML><HEAD></HEAD><BODY><P>I mean as a condition in an expression</P></BODY></HTML> Mon, 02 Dec 2013 20:06:30 GMT https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516637#M550339 nboccassini 2013-12-02T20:06:30Z Re: Expanded dimension https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516638#M550340 <HTML><HEAD></HEAD><BODY><P>The dimensionality() function should be what you're looking for. For the first dimension, it should return 1, when its expanded to the second dimension, the value will turn to 2, and so on.</P><P></P><P>Hope this helps!</P></BODY></HTML> Mon, 02 Dec 2013 20:12:44 GMT https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516638#M550340 jerem1234 2013-12-02T20:12:44Z Re: Expanded dimension https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516639#M550341 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can use Dimensionality function <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> in an expression</SPAN></P></BODY></HTML> Mon, 02 Dec 2013 20:15:08 GMT https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516639#M550341 2013-12-02T20:15:08Z Re: Expanded dimension https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516640#M550342 <HTML><HEAD></HEAD><BODY><P>In point of fact I want to resolve this problem <A href="https://community.qlik.com/thread/100410">Hide row in pivot table</A>, so I'm trying different ways. </P></BODY></HTML> Mon, 02 Dec 2013 20:54:11 GMT https://community.qlik.com/t5/QlikView/Expanded-dimension/m-p/516640#M550342 nboccassini 2013-12-02T20:54:11Z