Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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