topic Re: Get total sum range from table chart in App Development

Get total sum range from table chart

Eaun — Wed, 15 May 2019 13:55:03 GMT

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 ?

Re: Get total sum range from table chart

Lisa_P — Wed, 15 May 2019 23:36:49 GMT

Have you tried using this expression in a KPI chart?

Re: Get total sum range from table chart

Eaun — Thu, 16 May 2019 07:48:17 GMT

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?

Re: Get total sum range from table chart

Lisa_P — Thu, 16 May 2019 23:04:39 GMT

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

Re: Get total sum range from table chart

Eaun — Fri, 17 May 2019 07:57:27 GMT

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 : (