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: 
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.