Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))))