Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
hi,
find the attached qliksense App
Thanks, its working