Skip to main content
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'