topic SUM in QlikView https://community.qlik.com/t5/QlikView/SUM/m-p/981334#M335010 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P>This is how data in my data model appear</P><TABLE><TBODY><TR><TD>CLAIM_NO</TD><TD>LOSS_DATE</TD><TD>POLICY_NO</TD><TD>AMOUNT</TD><TD>POLICY_PERIOD</TD><TD>PREMIUM</TD><TD>DESC</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1200</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>SRCC TO VEHICLE</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1400</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>FLOOD COVER AND&nbsp; NATURAL PERILS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>14000</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>BASIC PREMIUM</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>5</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>ROAD SAFETY FUND</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>-2100</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>NO CLAIM BONUS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1200</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>SRCC TO VEHICLE</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1400</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>FLOOD COVER AND&nbsp; NATURAL PERILS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>-3500</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>NO CLAIM BONUS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>14000</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>BASIC PREMIUM</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>5</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>ROAD SAFETY FUND</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>0</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>FREE HEALTH COVER</TD></TR><TR><TD>CLGN001A15000021</TD><TD>06-Mar-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000021</TD><TD>06-Mar-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000023</TD><TD>08-Mar-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000036</TD><TD>15-Apr-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000063</TD><TD>16-Jul-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000063</TD><TD>16-Jul-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>I write the following expression but I do get sum of Amount Under Premium Column in below output report</P><P></P><P>if(len(trim(CLAIM_NO))&gt;0, sum(AMOUNT))</P><P></P><P>output report</P><TABLE><TBODY><TR><TD>RISK</TD><TD>POLICY_PERIOD</TD><TD>LOSS_DATE</TD><TD>POLICY_NO</TD><TD>CLAIM_NO</TD><TD>PREMIUM</TD></TR><TR><TD>17-6819</TD><TD>Aug-12 - Aug-13</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-12 - Aug-13</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-13 - Aug-14</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-13 - Aug-14</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>06-Mar-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000021</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>08-Mar-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000023</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>15-Apr-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000036</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>16-Jul-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000063</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-15 - Aug-16</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-15 - Aug-16</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Total</TD><TD></TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>Total</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>-</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="538"><TBODY><TR><TD class="xl70" height="17" style="border-top: none;"></TD><TD class="xl68" style="border-top: none;"></TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl68" style="border-top: none;"> </TD><TD class="xl68" style="border-top: none;"> </TD><TD class="xl69" style="border-top: none;">-</TD></TR></TBODY></TABLE><P></P><P>Pls help me to trace the error</P></BODY></HTML> Sat, 05 Sep 2015 18:34:26 GMT upaliwije 2015-09-05T18:34:26Z SUM https://community.qlik.com/t5/QlikView/SUM/m-p/981334#M335010 <HTML><HEAD></HEAD><BODY><P>Hi Friends</P><P>This is how data in my data model appear</P><TABLE><TBODY><TR><TD>CLAIM_NO</TD><TD>LOSS_DATE</TD><TD>POLICY_NO</TD><TD>AMOUNT</TD><TD>POLICY_PERIOD</TD><TD>PREMIUM</TD><TD>DESC</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1200</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>SRCC TO VEHICLE</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1400</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>FLOOD COVER AND&nbsp; NATURAL PERILS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>14000</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>BASIC PREMIUM</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>5</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>ROAD SAFETY FUND</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>-2100</TD><TD>Aug-12 - Aug-13</TD><TD>14505</TD><TD>NO CLAIM BONUS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1200</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>SRCC TO VEHICLE</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>1400</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>FLOOD COVER AND&nbsp; NATURAL PERILS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>-3500</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>NO CLAIM BONUS</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>14000</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>BASIC PREMIUM</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>5</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>ROAD SAFETY FUND</TD></TR><TR><TD></TD><TD></TD><TD>GN00111A0000119</TD><TD>0</TD><TD>Aug-14 - Aug-15</TD><TD>13105</TD><TD>FREE HEALTH COVER</TD></TR><TR><TD>CLGN001A15000021</TD><TD>06-Mar-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000021</TD><TD>06-Mar-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000023</TD><TD>08-Mar-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000036</TD><TD>15-Apr-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000063</TD><TD>16-Jul-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR><TR><TD>CLGN001A15000063</TD><TD>16-Jul-15</TD><TD>GN00111A0000119</TD><TD></TD><TD>Aug-14 - Aug-15</TD><TD></TD><TD></TD></TR></TBODY></TABLE><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>I write the following expression but I do get sum of Amount Under Premium Column in below output report</P><P></P><P>if(len(trim(CLAIM_NO))&gt;0, sum(AMOUNT))</P><P></P><P>output report</P><TABLE><TBODY><TR><TD>RISK</TD><TD>POLICY_PERIOD</TD><TD>LOSS_DATE</TD><TD>POLICY_NO</TD><TD>CLAIM_NO</TD><TD>PREMIUM</TD></TR><TR><TD>17-6819</TD><TD>Aug-12 - Aug-13</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-12 - Aug-13</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-13 - Aug-14</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-13 - Aug-14</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>06-Mar-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000021</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>08-Mar-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000023</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>15-Apr-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000036</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>16-Jul-15</TD><TD>GN00111A0000119</TD><TD>CLGN001A15000063</TD><TD>0</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-14 - Aug-15</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-15 - Aug-16</TD><TD>-</TD><TD>GN00111A0000119</TD><TD>-</TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Aug-15 - Aug-16</TD><TD>Total</TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>17-6819</TD><TD>Total</TD><TD></TD><TD></TD><TD></TD><TD>-</TD></TR><TR><TD>Total</TD><TD></TD><TD></TD><TD></TD><TD></TD><TD>-</TD></TR></TBODY></TABLE><TABLE border="0" cellpadding="0" cellspacing="0" width="538"><TBODY><TR><TD class="xl70" height="17" style="border-top: none;"></TD><TD class="xl68" style="border-top: none;"></TD><TD class="xl67" style="border-top: none;"> </TD><TD class="xl68" style="border-top: none;"> </TD><TD class="xl68" style="border-top: none;"> </TD><TD class="xl69" style="border-top: none;">-</TD></TR></TBODY></TABLE><P></P><P>Pls help me to trace the error</P></BODY></HTML> Sat, 05 Sep 2015 18:34:26 GMT https://community.qlik.com/t5/QlikView/SUM/m-p/981334#M335010 upaliwije 2015-09-05T18:34:26Z Re: SUM https://community.qlik.com/t5/QlikView/SUM/m-p/981335#M335011 <HTML><HEAD></HEAD><BODY><P>You output report - what is it? It looks like a Pivot Table due to the different Sub Totals ...</P><P></P><P>But the repeated values for the dimensions tells me otherwise?</P><P></P><P>Do you have some example spreadsheet and an explanation on what you have made in QlikView already - or even an upload of the QVW to share?</P></BODY></HTML> Sat, 05 Sep 2015 21:20:40 GMT https://community.qlik.com/t5/QlikView/SUM/m-p/981335#M335011 petter 2015-09-05T21:20:40Z