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
May be try like this:
sum({< Column = {">=0"}>} QTY)
In Script:
if(Column < 0, -sum(Column),Rangesum(sum(Column))) as NegSum;
sum({< Column = {"<=0"}>} QTY)
Hi Deepak
like below,
=sum({< [(Sum(Qty-1)-sum(Qty-2))*Avg(Amt)] ={"<=0"}>} [(Sum(Qty-1)-sum(Qty-2))*Avg(Amt)] )
I dont see any value reflecting for that, can you share the app if you have done it?
Post some, sample data here, excel sheet is not opening, it's taking long time to open...
Hi,
Deepak
if you not getting the answer ,rename your field and try above expression
find the attached App
balabhaskarqlik i have added, please check it
Its in qlik sense, can you just post that working expression
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)] )