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

How to set in a line chart graph color by custom condition used in set analysis in Qlik Sense 2019?

Hello qlikers 🙂
Great new color feature in Master Items to assign a color to a dimension doesn't work in some cases.

For example I want to set color by Year in a weekly line chart for sum or count of values. 
I use set analysis to draw 3 lines for 3 years. To simplify lets imagine I use static years 2017, 2018, 2019.

The Year lines has no individual color setting. Common color only, or by dimensions, or by expression.
1. Common color not enough.
2. By dimension works in a wrong way for me.

3. If I use color by expression I need to find out what this line exactly is.
The question is how to find out what set analysis condition I use for the measure?
Or what order number of line in a chart line is?

Or something line that to identify exactly what this line is.

Thanks in advance.
Alexey

Labels (4)
1 Reply
Diter
Contributor III
Contributor III

Hi

Maybe you can use a set condition like this:  if([year]=2017, rgb(30,144,255), if([year]=2018, rgb(255,69,0), if([year]=2019, rgb(255,215,0))))