Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Barry-Gon
Contributor II
Contributor II

Change color on line char when max value is reached

Hello,

I have a line chart, with full accumulation expresion.

The "x" Axis is dinamyc, when is 1 or 2 months selected show the days. When is geater than 2 and less than 11 show weeks, when is the complete year show months and year. 

I would like to change the color to transparent when the full accumulation is equal to max value as shown below:

Barry-Gon_0-1613148104126.png

 

For some reason when I make some specific selections (souch as bookmars "Skipping Lines 1" and "Skipping Lines 2" into the attached file) the chart behavior shows as the image below:

Barry-Gon_1-1613148952519.png

 

How could I manage when the max value is reached change the line color to transparent in this case? Any adivce?

 

Please help

 

Thank you

 

 

1 Reply
PradeepK
Creator II
Creator II

Line ColorMix1.PNG

 

ColorMix1(
	(sum(quantity) - Min(Total<customer> quantity))
    / Max(Total<customer> quantity)
    ,color(FieldIndex('customer',customer)), white()
)

Try mixing max color with background color.