topic Re: How to Change Background Color in Pivot Table in QlikView

How to Change Background Color in Pivot Table

panipat1990 — Wed, 25 Nov 2020 16:16:04 GMT

Dear Team,

i Stuck a requirement. i want to change background color of Second dimension.

in my Table 3 field

Field1

Field2

Field3

I made a pivot table. I used Field 1 and field 2 as a column

and field 3 as Raw level.And Measure is sum(Sale)

In Field2 i have a Value 1,2,3,4,5,6,7,8,

My Requirement is Background of 1 Show Red Color

Background of 1 Show Yellow Color

Background of 1 Show GreenColor

Background of 1 Show OrangeColor

For this i am Sharing Data And Qvw. Kindly Help me for resolving this requirement

madhumitha — Mon, 13 Nov 2017 10:59:56 GMT

Hello Gourav,

Please find attached file.

hope this helps

prma7799 — Mon, 13 Nov 2017 11:05:39 GMT

I you want to change background color on dimension then got to

Properties >> dimension >> select Dimension >> background color >> write condition here

panipat1990 — Mon, 13 Nov 2017 13:01:27 GMT

i know the way.but Kindly help me for resolving my problem

ieuyar — Mon, 13 Nov 2017 14:05:21 GMT

on field2 dimension, use below expression for background color:

=if(match(Field2,1,2,3,4),pick(match(Field2,1,2,3,4),red(),yellow(),green(),ColorMix1(0.5,red(),yellow())),white())

madhumitha — Mon, 13 Nov 2017 15:19:36 GMT

What exactly is your issue?

is that not working?

can you share more details??