topic Calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885782#M1014632 <HTML><HEAD></HEAD><BODY><P>I have an expression that does what its meant to do but I would like to change this to a calculated dimension as it would make more sense.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ColumnA</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Values</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">19</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">21</TD></TR></TBODY></TABLE><P></P><P></P><P>My current expression is </P><P></P><P>sum(values)/sum(total(values)</P><P></P><P>but I want to change this into a calculated dimension.</P><P></P><P>Any ideas?</P><P>Keep getting 'error' for what I am trying to do. Works fine as an expression but I am changing the design of the table and would prefer to have as a calculated dimension instead.</P><P></P><P>Thanks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 09 Apr 2015 11:24:07 GMT bobbydave 2015-04-09T11:24:07Z Calculated dimension https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885782#M1014632 <HTML><HEAD></HEAD><BODY><P>I have an expression that does what its meant to do but I would like to change this to a calculated dimension as it would make more sense.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ColumnA</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Values</TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">11</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">17</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">19</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">21</TD></TR></TBODY></TABLE><P></P><P></P><P>My current expression is </P><P></P><P>sum(values)/sum(total(values)</P><P></P><P>but I want to change this into a calculated dimension.</P><P></P><P>Any ideas?</P><P>Keep getting 'error' for what I am trying to do. Works fine as an expression but I am changing the design of the table and would prefer to have as a calculated dimension instead.</P><P></P><P>Thanks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Thu, 09 Apr 2015 11:24:07 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885782#M1014632 bobbydave 2015-04-09T11:24:07Z Re: Calculated dimension https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885783#M1014633 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P></P><P>aggr(sum(Values)/sum(TOTAL Values),ColumnA)</P></BODY></HTML> Thu, 09 Apr 2015 11:40:55 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885783#M1014633 pokassov 2015-04-09T11:40:55Z Re: Calculated dimension https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885784#M1014634 <HTML><HEAD></HEAD><BODY><P>Works a charm.</P><P>Thanks for that</P></BODY></HTML> Thu, 09 Apr 2015 12:07:51 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension/m-p/885784#M1014634 bobbydave 2015-04-09T12:07:51Z