topic Re: % calculation in QlikView https://community.qlik.com/t5/QlikView/calculation/m-p/986516#M336425 <HTML><HEAD></HEAD><BODY><P>That is not working</P></BODY></HTML> Sun, 20 Sep 2015 09:58:04 GMT upaliwije 2015-09-20T09:58:04Z % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/986514#M336423 <HTML><HEAD></HEAD><BODY><P>I have following Pivot table in my data model. I want calculate the % (highlighted in&nbsp; red). Pls help me</P><P></P><TABLE><TBODY><TR><TD></TD><TD></TD><TD><SPAN style="font-size: 8pt;">GROSS_PREMIUM</SPAN></TD><TD></TD><TD></TD><TD></TD></TR><TR><TD></TD><TD><SPAN style="font-size: 8pt;">BUSINESS_TYPE</SPAN></TD><TD><SPAN style="font-size: 8pt;">NEW_BUSI.</SPAN></TD><TD></TD><TD><SPAN style="font-size: 8pt;">RENEWALS</SPAN></TD><TD></TD></TR><TR><TD><SPAN style="font-size: 8pt;">DEPT</SPAN></TD><TD><SPAN style="font-size: 8pt;">BUSINESS_SOURCES</SPAN></TD><TD></TD><TD><SPAN style="color: #ff0000; font-size: 8pt;">%</SPAN></TD><TD></TD><TD><SPAN style="color: #ff0000; font-size: 8pt;">%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">HEAD</SPAN></TD><TD><SPAN style="font-size: 8pt;">A</SPAN></TD><TD><SPAN style="font-size: 8pt;">7,855,432</SPAN></TD><TD><SPAN style="font-size: 8pt;">18%</SPAN></TD><TD><SPAN style="font-size: 8pt;">11,920,417</SPAN></TD><TD><SPAN style="font-size: 8pt;">22%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">HEAD</SPAN></TD><TD><SPAN style="font-size: 8pt;">B</SPAN></TD><TD><SPAN style="font-size: 8pt;">2,559,225</SPAN></TD><TD><SPAN style="font-size: 8pt;">6%</SPAN></TD><TD><SPAN style="font-size: 8pt;">3,450,250</SPAN></TD><TD><SPAN style="font-size: 8pt;">6%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">HEAD</SPAN></TD><TD><SPAN style="font-size: 8pt;">C</SPAN></TD><TD><SPAN style="font-size: 8pt;">2,251,519</SPAN></TD><TD><SPAN style="font-size: 8pt;">5%</SPAN></TD><TD><SPAN style="font-size: 8pt;">1,744,495</SPAN></TD><TD><SPAN style="font-size: 8pt;">3%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">HEAD</SPAN></TD><TD><SPAN style="font-size: 8pt;">D</SPAN></TD><TD><SPAN style="font-size: 8pt;">29,875,702</SPAN></TD><TD><SPAN style="font-size: 8pt;">70%</SPAN></TD><TD><SPAN style="font-size: 8pt;">37,314,178</SPAN></TD><TD><SPAN style="font-size: 8pt;">69%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">HEAD</SPAN></TD><TD><SPAN style="font-size: 8pt;">Total</SPAN></TD><TD><SPAN style="font-size: 8pt;">42,541,878</SPAN></TD><TD><SPAN style="font-size: 8pt;">100%</SPAN></TD><TD><SPAN style="font-size: 8pt;">54,429,339</SPAN></TD><TD><SPAN style="font-size: 8pt;">100%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">CITY</SPAN></TD><TD><SPAN style="font-size: 8pt;">A</SPAN></TD><TD><SPAN style="font-size: 8pt;">10,018,210</SPAN></TD><TD><SPAN style="font-size: 8pt;">12%</SPAN></TD><TD><SPAN style="font-size: 8pt;">13,816,521</SPAN></TD><TD><SPAN style="font-size: 8pt;">15%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">CITY</SPAN></TD><TD><SPAN style="font-size: 8pt;">B</SPAN></TD><TD><SPAN style="font-size: 8pt;">3,760,713</SPAN></TD><TD><SPAN style="font-size: 8pt;">5%</SPAN></TD><TD><SPAN style="font-size: 8pt;">9,376,752</SPAN></TD><TD><SPAN style="font-size: 8pt;">10%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">CITY</SPAN></TD><TD><SPAN style="font-size: 8pt;">C</SPAN></TD><TD><SPAN style="font-size: 8pt;">1,084,472</SPAN></TD><TD><SPAN style="font-size: 8pt;">1%</SPAN></TD><TD><SPAN style="font-size: 8pt;">444,017</SPAN></TD><TD><SPAN style="font-size: 8pt;">0%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">CITY</SPAN></TD><TD><SPAN style="font-size: 8pt;">D</SPAN></TD><TD><SPAN style="font-size: 8pt;">68,240,497</SPAN></TD><TD><SPAN style="font-size: 8pt;">82%</SPAN></TD><TD><SPAN style="font-size: 8pt;">68,232,060</SPAN></TD><TD><SPAN style="font-size: 8pt;">74%</SPAN></TD></TR><TR><TD><SPAN style="font-size: 8pt;">CITY</SPAN></TD><TD><SPAN style="font-size: 8pt;">Total</SPAN></TD><TD>83,103,892</TD><TD>100%</TD><TD>91,869,351</TD><TD>100%</TD></TR></TBODY></TABLE><P></P><P>My present set expression is as follows</P><P>SUM({$&lt;POL_TYPE={'N','R','A'}&gt;}PREMIUM)</P></BODY></HTML> Sun, 20 Sep 2015 09:23:00 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/986514#M336423 upaliwije 2015-09-20T09:23:00Z Re: % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/986515#M336424 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">SUM({$&lt;POL_TYPE={'N','R','A'}&gt;}PREMIUM)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">/</SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SUM({$&lt;POL_TYPE={'N','R','A'}&gt;} total &lt;DEPT&gt; PREMIUM)</SPAN></P></BODY></HTML> Sun, 20 Sep 2015 09:31:09 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/986515#M336424 maxgro 2015-09-20T09:31:09Z Re: % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/986516#M336425 <HTML><HEAD></HEAD><BODY><P>That is not working</P></BODY></HTML> Sun, 20 Sep 2015 09:58:04 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/986516#M336425 upaliwije 2015-09-20T09:58:04Z Re: % calculation https://community.qlik.com/t5/QlikView/calculation/m-p/986517#M336426 <HTML><HEAD></HEAD><BODY><P>Sum( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">{$&lt;POL_TYPE={'N','R','A'}&gt;} </SPAN>PREMIUM) / Sum( <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">{$&lt;POL_TYPE={'N','R','A'}&gt;} </SPAN>TOTAL &lt;DEPT,BUSINESS_TYPE&gt; PREMIUM)</P><P></P><P><IMG alt="2015-09-20 #1.png" class="jive-image image-1" src="/legacyfs/online/99439_2015-09-20 #1.png" style="height: 137px; width: 620px;" /></P></BODY></HTML> Sun, 20 Sep 2015 10:06:20 GMT https://community.qlik.com/t5/QlikView/calculation/m-p/986517#M336426 petter 2015-09-20T10:06:20Z