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

alexeyrv — Sat, 16 Nov 2024 20:23:04 GMT

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

Re: How to set in a line chart graph color by custom condition used in set analysis in Qlik Sense 20

Diter — Thu, 25 Jul 2019 22:07:29 GMT

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))))

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

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

Re: How to set in a line chart graph color by custom condition used in set analysis in Qlik Sense 20