Color ranking in a chart

[#1]

I have been asked by my customers to produce a ranked chart where the background colour goes from green for rank 1 through yellow for the middle rank to red for the last rank. Given that the number of ranks can vary, I have tried to use RGB() to define the colours but it only applies to the first rank.

[rajeshvaswani77]

Go to expression background and there use an if condition to define the RGB values.

thanks,

Rajesh Vaswani

[Larry_Aaron]

In the Expression tab

Expression > Background Color > Definition > File > Colormix Wizard

[#4 · Accepted solution]

I have found another solution which does not require the use of the colormix wizard.

By using the HSL function, and defining certain hues:

HSL((GetPossibleCount(Field)-rank(RankingField)+1)/GetPossibleCount(Field)*80/255,240/255,120/255)

[v_iyyappan]

Hi,

     Using Visual Cues We get the color based on ranks. Attached a sample QV file.

May be its helpful for u.

Iyyappan

[#6]

Hi Russellangus,

I'm trying to do what you described (where multiple background range colours show all the time and not only when selected), but am battling to implement HSL - I'd really appreciate it if you could please elaborate on how you used it?