topic Re: Totals function (sum) for bar chart? in App Development

Totals function (sum) for bar chart?

Anonymous — Sat, 16 Nov 2024 08:13:34 GMT

Hi Qlik's communites,

I'm trying to get bar chart to show Total Sum like on the right value 143,382.54 (yellow highlighted). Of course this is on a table which can be change with the totals functions so it will not reflect sum of GRA 195,374.61 (yellow highlighted).

But in bar chart we're not given Totals function and the sum is 195,374.61. So how can I done this in bar chart or modification to my expression?

Re: Totals function (sum) for bar chart?

sunny_talwar — Thu, 24 May 2018 11:54:14 GMT

Try this

Sum(Aggr(

If(Currency = 'THB', Sum(Goods_Receipt_Amount)*vThaiRate, Sum(Goods_Receipt_Amount))

, Sub_Category, Currency))

Also, look here

http://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/ChartFunctions/NestedAggregations/sum-of-rows…‌

This link is for pivot table, but is applicable for other charts also

Re: Totals function (sum) for bar chart?

Anonymous — Fri, 25 May 2018 00:50:11 GMT

Yeap, like the other question, same formula

Re: Totals function (sum) for bar chart?

Fiorrie — Thu, 06 Jun 2019 07:46:04 GMT

Hi Sunny

I am facing the same issue, somehow it is not working despite using Sum(Aggr), can you please advise?

When I change to Sum in Total Function in the table is correct number but in the chart it is not excluding as it should.

Many thanks

IF(SUM(AGGR($(vPrice),[pn])) > SUM(AGGR($(vContrPrice),[pn]))
or SUM(AGGR($(vPrice),[pn])) = SUM(AGGR($(vContrPrice),[pn])),

FABS(SUM(AGGR($(vP_Lost_Test),[pn]))))