Expression not working in Table chart on Qlik Sense

kirankumarsonoco — Mon, 14 Feb 2022 12:39:11 GMT

Hi Team,

I have one expression below that expression is working in KPI Chart and not working in Table, Not working means when i have applied expression in table only one record is showing, i want to show the negative date dimension wise, like plant and item combo first negative value like that remaining

Please suggest ASAP

firstsortedvalue(REAL_DATE,

aggr(if(

($(vOnhand)) + aggr(rangesum(above((ProjInv_Actuals1),1,rowno())),REAL_DATE)<0,

REAL_DATE),

REAL_DATE))

topic Expression not working in Table chart on Qlik Sense in App Development

Expression not working in Table chart on Qlik Sense