Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kirankumarsonoco
Contributor II
Contributor II

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