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!

Announcements
Register for Public Instructor-Led Classes and Save 50%. START LEARNING
cancel
Showing results for
Did you mean:
Highlighted
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
Highlighted
MVP

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

4 Replies
Highlighted
MVP & Luminary

Perhaps like this:

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

talk is cheap, supply exceeds demand
Highlighted
Contributor III

no its not working

Highlighted
Contributor III

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

Highlighted
MVP

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

Community Browser