topic Re: Color Coding Pivot Table in App Development

Color Coding Pivot Table

philip_radovich — Tue, 17 May 2016 10:53:34 GMT

Hi,

I am trying to color code the values of my pivot table based on the different dimensions in the column section. I have the AVG Value as the measure and I currently have this If (Avg(Value)>=1500, RGB(87,149,50), RGB(170,57,57)) for my background color expression but it highlights every single value instead of the specific one's I need in the column. Is there a way to set the color of each value different based on the parameters needed for the column?

Thanks,

Philip Radovich

Re: Color Coding Pivot Table

sunny_talwar — Tue, 17 May 2016 23:28:39 GMT

Is this not what you are expecting?

When Avg(Value) >=1500 the color is green and when it is below 1500 it is red?

Re: Color Coding Pivot Table

Chanty4u — Wed, 18 May 2016 05:25:05 GMT

I think this question about Qliksense .

Goto colur tab and give colours based on expresion same the expression what u have

Re: Color Coding Pivot Table

sunny_talwar — Wed, 18 May 2016 08:26:03 GMT

My bad

Re: Color Coding Pivot Table

Chanty4u — Wed, 18 May 2016 08:30:52 GMT

No worries bro.even though it is correct if he uses Qlikview