topic Re: How to sum two diff field values in charts in QlikView https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132864#M901331 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P>Dimension</P><P><STRONG>Org id</STRONG></P><P></P><P>Expression1</P><P><STRONG>MinString(Organization)</STRONG></P><P>and your other two expressions....</P></BODY></HTML> Mon, 11 Jul 2016 16:36:56 GMT sunny_talwar 2016-07-11T16:36:56Z How to sum two diff field values in charts https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132863#M901330 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp;&nbsp; .</P><P>How can I sum the requests and problems columns and show only one organization name for the aggregated result</P><P></P><P></P><P>Data:</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 600px;"><TBODY><TR><TD height="17" width="75">Org id</TD><TD class="xl63" width="156">Organization</TD><TD class="xl63" style="border-left: none;" width="93"># Requests</TD><TD class="xl63" style="border-left: none;" width="100"># Problems</TD></TR><TR><TD class="xl64" style="border-top: none;"> </TD><TD align="right" class="xl65" style="border-top: none; border-left: none;"></TD><TD align="right" class="xl66" style="border-top: none; border-left: none;"></TD><TD></TD></TR><TR><TD align="right" height="17">1145</TD><TD class="xl67" style="border-top: none;"> (AHS)</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">36</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">140</TD></TR><TR><TD align="right" height="17">1145</TD><TD class="xl67" style="border-top: none;"> (AHS) - 1.0</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">634,381</TD><TD align="right" class="xl68" style="border-top: none; border-left: none;">4,427,468</TD></TR></TBODY></TABLE><P></P><P>Expected output:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 600px;"><TBODY><TR><TD height="17" width="75"><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY></TBODY></TABLE>Org id</TD><TD class="xl65" width="156">Organization</TD><TD class="xl65" style="border-left: none;" width="93"># Requests</TD><TD class="xl65" style="border-left: none;" width="100"># Problems</TD></TR><TR><TD class="xl66" style="border-top: none;"> <SPAN style="font-size: 13.3333px; text-align: -webkit-right;">1145</SPAN></TD><TD align="right" class="xl67" style="border-top: none;"><SPAN style="font-size: 13.3333px;"> (AHS)</SPAN></TD><TD align="right" class="xl67" style="border-top: none; border-left: none;"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">634,417</SPAN></TD><TD align="right" class="xl68" style="border-top: none; border-left: none;"><SPAN style="font-size: 13.3333px; text-align: -webkit-right;">4,427,608</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132863#M901330 2020-11-25T16:16:04Z Re: How to sum two diff field values in charts https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132864#M901331 <HTML><HEAD></HEAD><BODY><P>May be try this:</P><P></P><P>Dimension</P><P><STRONG>Org id</STRONG></P><P></P><P>Expression1</P><P><STRONG>MinString(Organization)</STRONG></P><P>and your other two expressions....</P></BODY></HTML> Mon, 11 Jul 2016 16:36:56 GMT https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132864#M901331 sunny_talwar 2016-07-11T16:36:56Z Re: How to sum two diff field values in charts https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132865#M901332 <HTML><HEAD></HEAD><BODY><P>Thx Sunny</P></BODY></HTML> Mon, 11 Jul 2016 16:47:45 GMT https://community.qlik.com/t5/QlikView/How-to-sum-two-diff-field-values-in-charts/m-p/1132865#M901332 2016-07-11T16:47:45Z