topic Re: Total sum wont come! in QlikView https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400797#M812054 <HTML><HEAD></HEAD><BODY><P>Dear Sunny,</P><P></P><P>This is a growth calculation over 3 Years 2015,2016,2017.&nbsp; <STRONG>105%</STRONG> growth is the increase from 2016 to 2017. <STRONG>27%</STRONG> implies the growth 2015 to 2016. For the total column, I prefer to get the growth from 2015 to 2017.That is the premium difference of&nbsp; Rs 1186 vs 455. As you inquired whether I need 27 of 105, I appreciate if you suggest me different expression to get all three different answers. Of course&nbsp; I mainly focus on growth between <STRONG>2017 vs</STRONG> <STRONG>2015.</STRONG></P><P></P><P>Thanks</P><P></P><P>Neville</P></BODY></HTML> Sat, 23 Sep 2017 11:34:54 GMT nevilledhamsiri 2017-09-23T11:34:54Z Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400791#M812048 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Dear</P><P>Once following expression was applied, total growth % wont come on the row. Please correct where I am wrong. </P><P></P><P>=Alt((Sum(GROSS_PREMIUM)-Below(TOTAL Sum(GROSS_PREMIUM), Count(DISTINCT TOTAL &lt;TRN_YEAR&gt; BRANCH_CODE)))</P><P></P><P>/Below(TOTAL Sum( GROSS_PREMIUM),Count(DISTINCT TOTAL &lt;TRN_YEAR&gt;BRANCH_CODE))*100, 0)</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/177522_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400791#M812048 nevilledhamsiri 2020-11-25T16:16:04Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400792#M812049 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>At initial level it looks like the Alt (0) is giving you the error. Just replace it with Expression of Total.</P></BODY></HTML> Sat, 23 Sep 2017 05:14:42 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400792#M812049 sujeetsingh 2017-09-23T05:14:42Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400793#M812050 <HTML><HEAD></HEAD><BODY><P>Dear Sujeet,</P><P></P><P>Once Total applied error comes, If you don't mind will you re write it &amp; send me!</P><P></P><P>Regards</P><P></P><P>Neville</P></BODY></HTML> Sat, 23 Sep 2017 05:30:08 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400793#M812050 nevilledhamsiri 2017-09-23T05:30:08Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400794#M812051 <HTML><HEAD></HEAD><BODY><P>Can you please share the sample file.</P></BODY></HTML> Sat, 23 Sep 2017 08:16:29 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400794#M812051 sujeetsingh 2017-09-23T08:16:29Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400795#M812052 <HTML><HEAD></HEAD><BODY><P>What number are you expecting to see for the total? Sum of 105 and 27 here?</P></BODY></HTML> Sat, 23 Sep 2017 11:07:41 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400795#M812052 sunny_talwar 2017-09-23T11:07:41Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400796#M812053 <HTML><HEAD></HEAD><BODY><P>Dear Sunny,</P><P></P><P>This is a growth calculation over 3 Years 2015,2016,2017.&nbsp; <STRONG>105%</STRONG> growth is the increase from 2016 to 2017. <STRONG>27%</STRONG> implies the growth 2015 to 2016. For the total column, I prefer to get the growth from 2015 to 2017.That is the premium difference of&nbsp; Rs 1186 vs 455. As you inquired whether I need 27 of 105, I appreciate if you suggest me different expression to get all three different answers. Of course&nbsp; I mainly focus on growth between 2015 vs 2015.</P><P></P><P>Thanks</P><P></P><P>Neville</P></BODY></HTML> Sat, 23 Sep 2017 11:33:33 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400796#M812053 nevilledhamsiri 2017-09-23T11:33:33Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400797#M812054 <HTML><HEAD></HEAD><BODY><P>Dear Sunny,</P><P></P><P>This is a growth calculation over 3 Years 2015,2016,2017.&nbsp; <STRONG>105%</STRONG> growth is the increase from 2016 to 2017. <STRONG>27%</STRONG> implies the growth 2015 to 2016. For the total column, I prefer to get the growth from 2015 to 2017.That is the premium difference of&nbsp; Rs 1186 vs 455. As you inquired whether I need 27 of 105, I appreciate if you suggest me different expression to get all three different answers. Of course&nbsp; I mainly focus on growth between <STRONG>2017 vs</STRONG> <STRONG>2015.</STRONG></P><P></P><P>Thanks</P><P></P><P>Neville</P></BODY></HTML> Sat, 23 Sep 2017 11:34:54 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400797#M812054 nevilledhamsiri 2017-09-23T11:34:54Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400798#M812055 <HTML><HEAD></HEAD><BODY><P>Please help to achieve this!</P><P></P><P></P><P>Regards</P><P></P><P>Neville</P></BODY></HTML> Sat, 23 Sep 2017 14:23:48 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400798#M812055 nevilledhamsiri 2017-09-23T14:23:48Z Re: Total sum wont come! https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400799#M812056 <HTML><HEAD></HEAD><BODY><P>Will you please look in to this!</P><P></P><P>Thanks</P><P></P><P>Neville</P></BODY></HTML> Sat, 23 Sep 2017 19:04:49 GMT https://community.qlik.com/t5/QlikView/Total-sum-wont-come/m-p/1400799#M812056 nevilledhamsiri 2017-09-23T19:04:49Z