# Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

New Contributor III

## Sum of Positive value from difference of two columns

Hi Can someone helpp me to get the output in KPI which contains the sum of only positive numbers. of 6 th Column

 Model Number Forecast Billing Quantity Forecast_2 Left Quantity (Sum(Forecast) - sum(Billing Quantity)) - (sum(Forecast_2)+sum(Left_Quantity)) Model-A 10 8 48 0 -46 Model-B 60 116 205 0 -261 Model-C 775 456 1832 0 -1513 Model-D 25 2 2 8 13 Model-E 52 59 2303 0 -2303 Model-F 80 10 20 3 47

Can we get the sum of only  positive value of  following expression in KPI:  i.e. 13+47 = 60

(Sum(Forecast) - sum(Billing Quantity)) - (sum(Forecast_2)+sum(Left_Quantity))

Thnaks

Rishabh

Labels (3)

• ### QlikView

1 Solution

Accepted Solutions MVP

## Re: Sum of Positive value from difference of two columns

``````Sum(Aggr(
RangeMax(0, (Sum(Forecast) - Sum(Billing Quantity)) - (Sum(Forecast_2)+Sum(Left_Quantity)))
, [Model Number]))``````

4 Replies MVP & Luminary

## Re: Sum of Positive value from difference of two columns

Perhaps like this:

RangeMax(0,(Sum(Forecast) - sum(Billing Quantity)) - (sum(Forecast_2)+sum(Left_Quantity)))

talk is cheap, supply exceeds demand
New Contributor III

## Re: Sum of Positive value from difference of two columns

no its not working

New Contributor III

## Re: Sum of Positive value from difference of two columns

hello @Gysbert_Wassenaar  your Expression works but only in Table form when I kept it in KPI then value gives 0 MVP

## Re: Sum of Positive value from difference of two columns

``````Sum(Aggr(