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

12 Replies
deepak_km9886
Creator
Creator
Author

Appreciate your effort, but i still see hyphen in the KPI, that kpi should return the sum of negative F values, else for positive and zero F values it should just show 0. like this

if(Column F <0,-(Sum of only negative F values), 0)

I'm making the sum of negative values to positive if the condition is true 

Anonymous
Not applicable

hi,

find the attached qliksense App

deepak_km9886
Creator
Creator
Author

Thanks, its working