Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokpaladugula
Contributor III
Contributor III

How to Sum less than equal 0 values to show on textbox

Hi All,

I;m unable to sum the negative values.

My scenario like this.

  

Delivery HoursShipment Count
-5100
-4150
-2200
0500
1300
2100

Now i want Sum the less than or equal '0' values in text object.

Please help me.

Thanks,

ASHOK

1 Solution

Accepted Solutions
Kushal_Chawda

=Sum({<DeliveryHours ={"<=0"}>}ShipmentCount)

View solution in original post

2 Replies
Kushal_Chawda

=Sum({<DeliveryHours ={"<=0"}>}ShipmentCount)

ashokpaladugula
Contributor III
Contributor III
Author

Thank  you.