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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
NickE93
Contributor
Contributor

The Chart is not Displayed Because it Contains Only Undefined Values

Hi,

I have a problem with creating a line chart.

Formula right table to get the cumulative quantity (per article, per day) and if an article is below 0 then value 0.

IF(sum(AGGR(rangesum(ABOVE(SUM(quantity) + SUM({1} 0),0,ROWNO())),ItemCode, (days, (numeric, Ascending))))<0,0,sum(AGGR(rangesum(ABOVE(SUM(quantity) + SUM({1} 0),0,ROWNO())),ItemCode, (days, (numeric, Ascending)))))

next thing i want to do is get the total quanity of al items per day but then i get the error: The Chart is not Displayed Because it Contains Only Undefined Values

Could someone help me?

Thanks

NickE93_0-1665662632189.png

 

Labels (1)
0 Replies