Get total sum range from table chart

[Eaun]

What want to do is get the sum total positive and negitive values from a table chart in a kip chart

the formula in the table chart is :

SUM((AGGR(SUM(TOTQTY),PART_NUMBER)-AGGR(SUM(HM000_MOHTQ),PART_NUMBER))*CIGMA_COST)

I'm not able to share the app or data due company rules.

What would be the best way to go about this ?

[Lisa_P]

Have you tried using this expression in a KPI chart?

[Eaun]

When use the formula in the KPI chart I can get the total negitive sum but then I want to get the total positive from lower range of the formula if that makes sense?

[Lisa_P]

Not sure what you are looking for. The total is the total including both positive and negative values

[Eaun]

I want to show both a negitive value would mean that there could be a problem at the point of receiving and a

positive could be a problem with the booking out of the stores not sure if its even possible in qlik in

excel it would just be sumif lower or higher : (