topic What is function of dimentionality? in QlikView https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368720#M137048 <HTML><HEAD></HEAD><BODY><P>What is function of dimensionality<A name="dimensionality"></A>( ) and secondarydimensionality() ? May be someone can give me the example about this usage.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 25 May 2012 05:56:19 GMT 2012-05-25T05:56:19Z What is function of dimentionality? https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368720#M137048 <HTML><HEAD></HEAD><BODY><P>What is function of dimensionality<A name="dimensionality"></A>( ) and secondarydimensionality() ? May be someone can give me the example about this usage.</P><P></P><P>Thanks</P></BODY></HTML> Fri, 25 May 2012 05:56:19 GMT https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368720#M137048 2012-05-25T05:56:19Z What is function of dimentionality? https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368721#M137049 <HTML><HEAD></HEAD><BODY><P>Create yourself a pivot table with any 3 dimensions. now set 2 expressions =Dimensionality() and =SecondaryDimensionality(). Ensure Partial Sums are ticked for all dimensions. Now drag one of the dimensions up to the top so it becomes horizontal. Take a look at the numbers...</P><P></P><P>Dimensionality() is mainly useful in pivot tables as it shows what level you are at. This enables some conditional expression or formatting to be used, for example in the background colour setting of an expression you could enter:</P><P></P><P>=IF(Dimensionality()=0,LightRed(),White())</P><P></P><P>Wherever Dimensionality was 0 (top level total) the background would be red, everywhere else it would be white. </P><P></P><P>You could also use it to show values in percent at a line level but real values in the subtotals, if you wanted to. The rweal power comes in showing different expressions when users expand dimensions as each expanded dimension adds another level of Dimensionality.&nbsp; SecondaryDimensionality is the same but for dimensions across the top.</P><P></P><P>Hope this helps,</P><P></P><P>Jason</P></BODY></HTML> Fri, 25 May 2012 07:10:27 GMT https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368721#M137049 Jason_Michaelides 2012-05-25T07:10:27Z What is function of dimentionality? https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368722#M137050 <HTML><HEAD></HEAD><BODY><P>May be you can give me the example file please. I'm not understand. Thanks for your explaination.</P></BODY></HTML> Fri, 25 May 2012 07:45:12 GMT https://community.qlik.com/t5/QlikView/What-is-function-of-dimentionality/m-p/368722#M137050 2012-05-25T07:45:12Z