topic Color ranking in a chart in QlikView

Color ranking in a chart

Tue, 21 Feb 2012 14:29:27 GMT

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.

Color ranking in a chart

rajeshvaswani77 — Tue, 21 Feb 2012 14:51:13 GMT

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

thanks,

Rajesh Vaswani

Color ranking in a chart

Larry_Aaron — Tue, 21 Feb 2012 15:04:50 GMT

In the Expression tab

Expression > Background Color > Definition > File > Colormix Wizard

Color ranking in a chart

Tue, 28 Feb 2012 09:19:11 GMT

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)

Re: Color ranking in a chart

v_iyyappan — Tue, 28 Feb 2012 10:43:58 GMT

Hi,

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

May be its helpful for u.

Iyyappan

Re: Color ranking in a chart

Fri, 01 Feb 2013 14:24:55 GMT

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?