topic Re: expression to calculate only one row in QlikView https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263871#M851718 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;Category = {'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Device + DHL + Clearance</SPAN>'}&gt;}Qty)</P><P></P><P>Edited : Forgot to add measure Qty</P></BODY></HTML> Fri, 24 Feb 2017 18:41:48 GMT MK_QSL 2017-02-24T18:41:48Z expression to calculate only one row https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263870#M851717 <HTML><HEAD></HEAD><BODY><P>I have the following information on excel sheet:</P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/154409_Untitled.png" style="height: auto; width: auto;" /></P><P>I need to calculate the sum of (Device + DHL + Clearance) like the following:</P><P>sum([Qty]) for <SPAN style="font-size: 13.3333px;">(Device + DHL + Clearance)</SPAN> row only</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263870#M851717 Anonymous 2020-11-25T16:16:04Z Re: expression to calculate only one row https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263871#M851718 <HTML><HEAD></HEAD><BODY><P>SUM({&lt;Category = {'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Device + DHL + Clearance</SPAN>'}&gt;}Qty)</P><P></P><P>Edited : Forgot to add measure Qty</P></BODY></HTML> Fri, 24 Feb 2017 18:41:48 GMT https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263871#M851718 MK_QSL 2017-02-24T18:41:48Z Re: expression to calculate only one row https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263872#M851719 <HTML><HEAD></HEAD><BODY><P>Hi Rolf,</P><P></P><P>May be</P><P></P><P>Sum({&lt;Category={'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">Device + DHL + Clearance</SPAN>'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Qty</SPAN>)</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Fri, 24 Feb 2017 18:44:52 GMT https://community.qlik.com/t5/QlikView/expression-to-calculate-only-one-row/m-p/1263872#M851719 ahaahaaha 2017-02-24T18:44:52Z