topic Re: Background color by sort in QlikView

Background color by sort

Anonymous — Tue, 18 Feb 2014 18:30:33 GMT

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,

Re: Background color by sort

MK_QSL — Tue, 18 Feb 2014 18:41:16 GMT

Can you describe your problem in brief.

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

Re: Background color by sort

Anonymous — Tue, 18 Feb 2014 18:46:58 GMT

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.

Re: Background color by sort

chiru_thota — Tue, 18 Feb 2014 18:49:09 GMT

(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

Re: Re: Background color by sort

Tue, 18 Feb 2014 18:49:27 GMT

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

Re: Background color by sort

Anonymous — Tue, 18 Feb 2014 18:51:41 GMT

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

Re: Background color by sort

Tue, 18 Feb 2014 18:58:20 GMT

Hi Vladimir,

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

Regards

Roland

Re: Background color by sort

MK_QSL — Tue, 18 Feb 2014 18:59:18 GMT

Do you have specific predefined criteria for color

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.

Re: Background color by sort

Gysbert_Wassenaar — Tue, 18 Feb 2014 19:02:26 GMT

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.

Re: Background color by sort

Anonymous — Tue, 18 Feb 2014 19:35:01 GMT

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