Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepak_km9886
Creator
Creator

Sum of only negative numbers from the table column

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

1 Solution

Accepted Solutions
Anonymous
Not applicable

hi,

find the attached qliksense App

View solution in original post

12 Replies
balabhaskarqlik

May be try like this:

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

In Script:

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

balabhaskarqlik

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

Anonymous
Not applicable

Hi  Deepak

like below,

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

deepak_km9886
Creator
Creator
Author

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

balabhaskarqlik

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

Anonymous
Not applicable

Hi,

  Deepak


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

find the attached App

deepak_km9886
Creator
Creator
Author

balabhaskarqlik‌ i have added, please check it

deepak_km9886
Creator
Creator
Author

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

Anonymous
Not applicable

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)] )