topic Re: How to get the total from the below chart ? in QlikView

How to get the total from the below chart ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please have a look of my chart :

The RO expression is :

=if(SUM(recommended_order_qty)=0 , sum(scheduled_receipts_yielded_unit) , Sum(recommended_order_qty))

Thus , when are doing total is not reflecting.

The Total should be : 7,628,457

Sample Qlikview attached.

sunny_talwar — Tue, 17 May 2016 08:11:52 GMT

Try this expression:

=Sum(Aggr(if(SUM(recommended_order_qty)=0 , sum(scheduled_receipts_yielded_unit) , Sum(recommended_order_qty)), [Planning Month]))

Gysbert_Wassenaar — Tue, 17 May 2016 08:12:36 GMT

Something like:

=sum(aggr(if(SUM(recommended_order_qty)=0 , sum(scheduled_receipts_yielded_unit) , Sum(recommended_order_qty)), [Planning Month]))

If the name of the field you use as dimension is not [Planning Month] then replace it with the actual name.

Note, if you use a straight table instead of a pivot table you can simply set the Total Mode of that expression to Sum of Rows. Much easier.