App Development

Discuss and learn more about Qlik Sense app development and usage.

Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More

Who Me Too'd this topic

americanetsMD
Contributor III
Contributor III

Line Chart Colour: line/area colour by Value

Hi everyone, 

could anyone please help me getting the colour correctly.

At the moment i colour the area by expression. If value is posivite - area is green, else , area is red.

What am i doing wrong here? 😞 

The Formula i use to get the colour is:

if(

num(Aggr(
RangeSum(Above(Sum(WertKumuliert ),0,12))
, Jahr, Monat)/1000,'#.##0 TEUR')

>=0, '#6db133', '#e31c18')

Labels (1)
Who Me Too'd this topic