Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.