topic Re: Sum in QlikView https://community.qlik.com/t5/QlikView/Sum/m-p/1231041#M392293 <HTML><HEAD></HEAD><BODY><P>Simple write </P><P><STRONG><BR /></STRONG></P><P><STRONG>Max([Risk(Nos)])</STRONG></P><P></P><P>Or</P><P></P><P><STRONG>Aggr(Max([Risk(Nos)]),POLICY_NO)</STRONG></P></BODY></HTML> Sun, 05 Mar 2017 04:10:37 GMT Anil_Babu_Samineni 2017-03-05T04:10:37Z Sum https://community.qlik.com/t5/QlikView/Sum/m-p/1231038#M392290 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In my QV Docuemnt I have following data</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" width="349"><TBODY><TR><TD class="xl63" height="17" width="121">POLICY_NO</TD><TD class="xl64" style="border-left: none;" width="126">CLAIM_NO</TD><TD class="xl65" width="38">Risk(Nos)</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">CO30151B0003813</TD><TD class="xl66" style="border-top: none; border-left: none;">CLCO301B16000002</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">21</TD></TR><TR><TD class="xl66" height="17" style="border-top: none;">CO30151B0003813</TD><TD class="xl66" style="border-top: none; border-left: none;">-</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">22</TD></TR><TR><TD class="xl68" height="17" style="border-top: none;">Total</TD><TD class="xl69" style="border-top: none;"> </TD><TD align="right" class="xl70" style="border-top: none; border-left: none;">43</TD></TR></TBODY></TABLE><P>I want to show max Risk(nos) in the total row of my pivot table . But I get 43 as shown above my expression is </P><P>sum(DISTINCT RISK).</P><P></P><P>Pls help me to correct it</P></BODY></HTML> Sun, 05 Mar 2017 03:46:14 GMT https://community.qlik.com/t5/QlikView/Sum/m-p/1231038#M392290 upaliwije 2017-03-05T03:46:14Z Re: Sum https://community.qlik.com/t5/QlikView/Sum/m-p/1231039#M392291 <HTML><HEAD></HEAD><BODY><P>Instead of "43" what are you expecting to see? May be 22</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/155251_Capture.PNG" style="height: auto;" /></P><P></P><P>Or this</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/155261_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sun, 05 Mar 2017 04:05:32 GMT https://community.qlik.com/t5/QlikView/Sum/m-p/1231039#M392291 Anil_Babu_Samineni 2017-03-05T04:05:32Z Re: Sum https://community.qlik.com/t5/QlikView/Sum/m-p/1231040#M392292 <HTML><HEAD></HEAD><BODY><P>yes 22 How Can I write the expression</P></BODY></HTML> Sun, 05 Mar 2017 04:08:59 GMT https://community.qlik.com/t5/QlikView/Sum/m-p/1231040#M392292 upaliwije 2017-03-05T04:08:59Z Re: Sum https://community.qlik.com/t5/QlikView/Sum/m-p/1231041#M392293 <HTML><HEAD></HEAD><BODY><P>Simple write </P><P><STRONG><BR /></STRONG></P><P><STRONG>Max([Risk(Nos)])</STRONG></P><P></P><P>Or</P><P></P><P><STRONG>Aggr(Max([Risk(Nos)]),POLICY_NO)</STRONG></P></BODY></HTML> Sun, 05 Mar 2017 04:10:37 GMT https://community.qlik.com/t5/QlikView/Sum/m-p/1231041#M392293 Anil_Babu_Samineni 2017-03-05T04:10:37Z