Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ 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

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