Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
mmarchese
Creator II
Creator II

Better line chart colors?

My chart shows revenue over time for the top 5 customers in the current selection.  There are hundreds of customers, but I limited it to 5 so that the chart wouldn't be too chaotic.

The problem is that Qlik's choice of colors is abysmal.  I assume this is a bug in which Qlik picks the colors as if all customers were being shown rather than just 5.  Behold:

puke.png

 

I tried setting the color based on an expression instead, which did result in better colors, but it's useless because, for some baffling reason, it hides the legend:

no legend.png

Is there some way to get a decent variety of colors on this chart AND a legend?

(By the way, I cannot solve this by assigning colors to specific customers in the Customer dimension's settings because which particular 5 customers will be shown will vary.)

1 Reply
robert99
Specialist III
Specialist III

(By the way, I cannot solve this by assigning colors to specific customers in the Customer dimension's settings because which particular 5 customers will be shown will vary.)

That's the way I did this. Set up a master dimension and used 'value colors' to set the color for the required customers

NB You can auto fill and change as required

Then used colors and legends 'Show legend'