Sum of only negative numbers from the table column

[deepak_km9886]

I have attached a excel sheet, where in i have 6 columns, i have an KPI in my dashboard, that KPI should display only the sum of negative numbers from the column named 'F'.

How to achieve this? stalwar1‌

[BalaBhaskar_Qlik]

May be try like this:

sum({< Column = {">=0"}>} QTY)

In Script:

if(Column < 0, -sum(Column),Rangesum(sum(Column))) as NegSum;

[BalaBhaskar_Qlik]

sum({< Column = {"<=0"}>} QTY)

[Anonymous]

Hi  Deepak

like below,

=sum({< [(Sum(Qty-1)-sum(Qty-2))*Avg(Amt)] ={"<=0"}>} [(Sum(Qty-1)-sum(Qty-2))*Avg(Amt)] )

[deepak_km9886]

I dont see any value reflecting for that, can you share the app if you have done it?

[BalaBhaskar_Qlik]

Post some, sample data here, excel sheet is not opening, it's taking long time to open...

[Anonymous]

Hi,

  Deepak

if you not getting the answer ,rename your  field and try above expression

find the attached App

[deepak_km9886]

balabhaskarqlik‌ i have added, please check it

[deepak_km9886]

Its in qlik sense, can you just post that working expression

[Anonymous]

Hi

Deepak

same expression worked in qlik sense also i have done

=sum({< [(Sum(Qty-1)-sum(Qty-2))*Avg(Amt)] ={"<=0"}>} [(Sum(Qty-1)-sum(Qty-2))*Avg(Amt)] )