topic Re: color as per values in QlikView

color as per values

deepakqlikview_123 — Mon, 25 May 2015 12:00:28 GMT

Hi All,

PFA.

Below is requirement.

This is a percentile ranking in an ascending manner. The lowest value (in %) will appear at the top and the highest value (in %) will always at the bottome. For the color logic - the lowest value will always be in the darkest RED shade reducing to light red, then amber, then yellow, then light green and then dark green for the highest value. In short, the lowest value on the top will always be in dark red color and then it gets lighter and becomes green as the values increase.

Can you please suggest on this.

I have attached my sample application for this.

Thanks

Re: color as per values

marcus_sommer — Mon, 25 May 2015 12:29:26 GMT

Are you sure that you want to color the rows depending from their position? Then you could use color(rowno()) as expression and defined your colors within the color-tab from the object.

But if you want to color to the values you could use an if-loop like:

if(value < X, rgb(xyz), if(value < Z, rgb(a,b,d), ....

the same logic maybe more elegant solved with a pick(match()) approach.

I think the are further possibilities, maybe with colormix(). See also postings like this: Colors in charts.

- Marcus

Re: color as per values

Mon, 25 May 2015 13:09:03 GMT

Sort the expression in ascending order and then use the Color(Rowno())..

Re: color as per values

deepakqlikview_123 — Mon, 25 May 2015 13:36:46 GMT

Hi All,

Using rowno() is ok.But can you please suggest how shall i use this in colormix wizard as there is need to show different shades as shown in attachment.

Thanks

Re: color as per values

marcus_sommer — Mon, 25 May 2015 14:01:52 GMT

I would try for the first attempt the colormix2(x, red(), green(), yellow()) without the wizard. To generate the x-value depending on the row won't be easy and I'm not sure if you could get excactly such a color-shades over many table-rows as in a single object like a bar or a textbox-background.

Quite similar seems to be color-functions like colormaphue() or colormapjet().

- Marcus

Re: color as per values

deepakqlikview_123 — Mon, 25 May 2015 14:12:21 GMT

how to use Color(Rowno()).. in application i am not able to use it.

Re: color as per values

marcus_sommer — Mon, 25 May 2015 14:15:14 GMT

It will be applied as attribut-expression. Press by the expressions (dimensions is the same) the plus-sign and you get access to various attributs - see for this also the above mentioned blog Colors in charts.

- Marcus

Re: color as per values

rwunderlich — Mon, 25 May 2015 14:34:05 GMT

It looks to me like the colors in your example are fine as is. You just need to get the rows sorted in the order low to high, is that correct?

-Rob

Re: color as per values

Mon, 25 May 2015 14:37:38 GMT

thanks .. nice tip

Re: color as per values

deepakqlikview_123 — Mon, 25 May 2015 17:00:54 GMT

Hi Rob,

After sorting also i am not able to get desired output.

I have attached sample QVW and screenshot as per requirement for this please suggest.

Thanks

Re: color as per values

rwunderlich — Mon, 25 May 2015 17:10:51 GMT

I made your example a straight table just to make it sort easier. It looks like your screenshot to me. Is this what you are after?

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: color as per values

deepakqlikview_123 — Tue, 26 May 2015 05:15:16 GMT

Hi Rob,

Thanks for your inputs.

But i want to show grouping as per high risk value and low risk value as shown in attachment.

Such grouping is not possible in straight table.

Thanks