Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

ashokpaladugula
New 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

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

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

View solution in original post

2 Replies

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

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

View solution in original post

ashokpaladugula
New Contributor III

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

Thank  you.