Need help finding AGG Sum of items for NEXT date that has result >0
Hello Qlik Gurus!
I am having a hard time find an AGG SUM for a KPI measure.
I need to agg the sum and display the total for the NEXT date that is not a total of 0.
I am trying with something like If(Sum([Transfer Target]) = 0, '-',min(Aggr(If(Date >=Today(),Sum([Transfer Target]), ''),Date))), but in the dataset attached, I still get a 0.
