Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kirankumarsonoco
Contributor III
Contributor III

Expression not working in Table chart on Qlik Sense

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))

Labels (4)
0 Replies