topic Error of calculated dimension in QlikView https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278786#M619327 <HTML><HEAD></HEAD><BODY><P>Hello </P><P></P><P>I don't understand why i have this error: "<SPAN lang="en">Error of calculated dimension</SPAN>" when i simply execute this : =sum(qterr)/sum(qterb) in a simple table.</P><P></P><P>qterr and qterb come from a SQL query.</P><P></P><P>Regards.</P></BODY></HTML> Tue, 28 Feb 2017 08:44:07 GMT 2017-02-28T08:44:07Z Error of calculated dimension https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278786#M619327 <HTML><HEAD></HEAD><BODY><P>Hello </P><P></P><P>I don't understand why i have this error: "<SPAN lang="en">Error of calculated dimension</SPAN>" when i simply execute this : =sum(qterr)/sum(qterb) in a simple table.</P><P></P><P>qterr and qterb come from a SQL query.</P><P></P><P>Regards.</P></BODY></HTML> Tue, 28 Feb 2017 08:44:07 GMT https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278786#M619327 2017-02-28T08:44:07Z Re: Error of calculated dimension https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278787#M619328 <HTML><HEAD></HEAD><BODY><P>You should not use aggregation functions in a calculated dimension without using advanced aggregation (i.e. the aggr() function). A dimension should return something 1-dimensional, not a scalar.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3015">Dimensions and Measures</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2967">AGGR...</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2980">When should the Aggr() function NOT be used?</A></P></BODY></HTML> Tue, 28 Feb 2017 09:33:27 GMT https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278787#M619328 swuehl 2017-02-28T09:33:27Z Re: Error of calculated dimension https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278788#M619329 <HTML><HEAD></HEAD><BODY><P>What is your Dimension?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=sum(qterr)/sum(qterb) should be entered as an<STRONG> Expression</STRONG>, not dimension.</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P></BODY></HTML> Tue, 28 Feb 2017 09:33:35 GMT https://community.qlik.com/t5/QlikView/Error-of-calculated-dimension/m-p/1278788#M619329 Anonymous 2017-02-28T09:33:35Z