Background color by sort

[Anonymous]

Hi guys,

I'm stuck with background color of cells in pivot table.

I want to colors of cells always were the same colors for bigger to smaller data.

I used pick, it didn't work

Please see my example.

thanks,

[MK_QSL]

Can you describe your problem in brief.

I don't get it by reading your question or even looking your qvw file.

[Anonymous]

I want to make colors  from bigger to smaller according results.

Browse -27% should be red,

Shop spec -17% -blue

and so on

Next time Shop spec will be bigger then other it should be red and so on.

[chiru_thota]

(1) Do you want color for entire row or particular cell ?

(2) When you want to give color for cells you should know exact criteria .So that you can write a expression in background color of expression.

Ex : if it > value blue, if it is < value red...etc

Thanks,

Chiru

[#5]

Does this help. The max value will be one color and the min value will be another.

[Anonymous]

That should be bar chart, then I should use the same legend for other chart

[#7]

Hi Vladimir,

hope this exmaple points into right direction, using one of the colormix() functions

Regards

Roland

[MK_QSL]

Do you have specific predefined criteria for color

Like

If(count([qID_15863_Purpose of Visit])/count(TOTAL [qID_15863_Purpose of Visit]) >= '25%', Red(), Blue())

There is a good video on YOUTUBE named Controlling Colors in Chart by QlikTips.

Please watch it, might be useful.

[Gysbert_Wassenaar]

You can use the rank function or you can construct a color expression with the Colormix Wizard. You can find that wizard in the File menu of the Expression Editor. See attached qvw.

[Anonymous]

pick(rank(count({<[qID_15863_Purpose of Visit]=>}[qID_15863_Purpose of Visit])/

count({<[qID_15863_Purpose of Visit]=>}TOTAL [qID_15863_Purpose of Visit])),rgb(245,125,37),rgb(216,216,216),rgb(73,73,73),rgb(3,135,171),rgb(206,229,105),rgb(243,75,50),rgb(103,205,217),rgb(64,82,110))

I can choose any color for each result