topic Make % and sum in QlikView https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548021#M482149 <HTML><HEAD></HEAD><BODY><P>I am trying to get qlikview to make a sum of each level of dekningsklasse , and I have added a calculated dimension.</P><P></P><P></P><P>=sum( aggr( count( value), Bokførtverdi, Dekningsklasse))</P><P></P><P>However this doens't work.</P><P></P><P>I would like it to appear at the bottom.</P></BODY></HTML> Thu, 29 Aug 2013 12:04:15 GMT 2013-08-29T12:04:15Z Make % and sum https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548021#M482149 <HTML><HEAD></HEAD><BODY><P>I am trying to get qlikview to make a sum of each level of dekningsklasse , and I have added a calculated dimension.</P><P></P><P></P><P>=sum( aggr( count( value), Bokførtverdi, Dekningsklasse))</P><P></P><P>However this doens't work.</P><P></P><P>I would like it to appear at the bottom.</P></BODY></HTML> Thu, 29 Aug 2013 12:04:15 GMT https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548021#M482149 2013-08-29T12:04:15Z Re: Make % and sum https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548022#M482150 <HTML><HEAD></HEAD><BODY><P>Please attach small demo application for the same it is difficult to give ans on this </P><P></P><P>Vikas</P></BODY></HTML> Thu, 29 Aug 2013 12:11:50 GMT https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548022#M482150 vikasmahajan 2013-08-29T12:11:50Z Re: Make % and sum https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548023#M482151 <HTML><HEAD></HEAD><BODY><P>Sum({&lt;Dekningsklasse={$(='1')}&gt;}Bokførtverdi)/Sum(ALL{&lt;Dekningsklasse={$(='1')}&gt;}Bokførtverdi)</P><P></P><P>But that yield nothing either in terms of setting the percent right</P></BODY></HTML> Thu, 29 Aug 2013 12:25:20 GMT https://community.qlik.com/t5/QlikView/Make-and-sum/m-p/548023#M482151 2013-08-29T12:25:20Z