Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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?
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 : (