topic Re: Color in pivot table in QlikView

Color in pivot table

Tue, 18 Dec 2012 12:53:36 GMT

Hi all,

I have a pivot table that looks similar to

group Min_group 0-15 16-30 31-45 45-60

major 0 5 2 3

minor 6 1 4 2

when minutes is 0-15 and 16-30 and 31-45 i want the values of major and minor to display RED color and for 45-60 in GREEN.

I tried to change color's in visual cue tab but it only shows expressions. Group and Min_group are my dimensions and not expressions so after selecting dimension (group), clicked on + sign and in background color I wrote the expression

If(group = 'major' and Min_group = '0-15', group = RGB(255,0,0)) --> Didnt work so I changed it to

If(group = 'major' and Min_group = '0-15', RGB(255,0,0)) ---> Didnt work.

Re: Color in pivot table

Gysbert_Wassenaar — Tue, 18 Dec 2012 14:04:54 GMT

This one works for me:

if(group='major' and Min_Group='0-15',rgb(255,0,0))

See attached qvw

Re: Color in pivot table

Tue, 18 Dec 2012 18:44:28 GMT

Nope. Doesnt work. Cant understand what the issue is.

Re: Color in pivot table

Fri, 28 Dec 2012 16:27:34 GMT

It worked. When I grouped them in the load script, it assisgned as '0 - 15' and etc. That space between 0 and - and - and 15 was the problem as I was calling it in the expression as '0-15' rather than '0 - 15'.

Thanks.