https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696485#M53277 <P>How can I replace the Dimension fields to Measures?</P> Fri, 24 Apr 2020 12:29:20 GMT 17mcmc20 2020-04-24T12:29:20Z https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696353#M53264 <P>Hi All,</P><P>I have created a table (not a Pivot table) for the scorecard. I need to calculate the total column-wise for <STRONG>Development</STRONG> and <STRONG>Current</STRONG></P><TABLE width="404"><TBODY><TR><TD width="55">Score</TD><TD width="89"><FONT color="#FF0000">Development</FONT></TD><TD width="53"><FONT color="#FF0000">Current</FONT></TD><TD width="207"><P><FONT color="#008000">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Change </FONT></P><P><FONT color="#008000">(Development - Current)</FONT></P></TD></TR><TR><TD>0-200</TD><TD>123</TD><TD>112</TD><TD>11</TD></TR><TR><TD>200-400</TD><TD>345</TD><TD>320</TD><TD>25</TD></TR><TR><TD>400-600</TD><TD>678</TD><TD>650</TD><TD>28</TD></TR><TR><TD>600-800</TD><TD>910</TD><TD>909</TD><TD>1</TD></TR><TR><TD>800+</TD><TD>1010</TD><TD>1000</TD><TD>10</TD></TR><TR><TD><STRONG>TOTAL</STRONG></TD><TD><FONT face="arial black,avant garde" color="#000080"><STRONG>3066</STRONG></FONT></TD><TD><FONT face="arial black,avant garde" color="#000080"><STRONG>2991</STRONG></FONT></TD><TD><STRONG>75</STRONG></TD></TR></TBODY></TABLE><P><STRONG>NOTE: Development, Current is Dimensions;&nbsp; Change is Measure</STRONG></P><P>Any suggestions would be really helpful.</P> Sat, 16 Nov 2024 18:44:24 GMT https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696353#M53264 17mcmc20 2024-11-16T18:44:24Z https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696433#M53272 <P>Can you just maybe replace those dimension fields with measures?</P><P>Something like:</P><P>sum(Development)</P><P>sum(Current)</P> Fri, 24 Apr 2020 10:16:42 GMT https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696433#M53272 lorenzoconforti 2020-04-24T10:16:42Z https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696485#M53277 <P>How can I replace the Dimension fields to Measures?</P> Fri, 24 Apr 2020 12:29:20 GMT https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696485#M53277 17mcmc20 2020-04-24T12:29:20Z https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696487#M53278 <P>Add column &gt;&nbsp; measure</P><P>only(Development)</P><P>&nbsp;</P><P>Add column &gt;&nbsp; measure</P><P>only(Current)</P> Fri, 24 Apr 2020 12:31:43 GMT https://community.qlik.com/t5/App-Development/Calculate-Column-Total/m-p/1696487#M53278 lorenzoconforti 2020-04-24T12:31:43Z