topic Re: How to change color in Pivot table? in QlikView

How to change color in Pivot table?

soha1902 — Wed, 21 May 2014 11:30:07 GMT

Hi All,

In pivot table, we are using 3 dimensions and 1 expression custom_value. Like below

But in pivot table it showing so many colmns. These column are loaded through inline.

Now I want to change cell color based on some condition. but there is only one expression and it showing many columns so please guide me where I need to write expression.

Thanks....

Re: How to change color in Pivot table?

Gysbert_Wassenaar — Wed, 21 May 2014 11:34:35 GMT

Click on the + in front of the expression. Then select Background Color. Next enter an expression in the Definition field to calculate the color based on your condition. For example =if(cus_value > 0, green(), red())

Re: How to change color in Pivot table?

soha1902 — Wed, 21 May 2014 11:38:12 GMT

This I know.....but the problem is we are using only one custom_expression and it showing number of columns. So I have no idea where to write expression.

Re: How to change color in Pivot table?

Gysbert_Wassenaar — Wed, 21 May 2014 11:42:39 GMT

If you want to give the cell values in the expression column(s) a color then use the expression background color option. If you want the values in the dimension columns to have different colors then click on the + in front of the dimension, select background color and click on the Edit button to enter the expression to calculate the color. You will have to do that for each dimension where you want to use conditional colors.

Re: How to change color in Pivot table?

soha1902 — Wed, 21 May 2014 11:50:37 GMT

Thanks for reply Gysbert....

Plz look my previous attachment there we are having one one expression but in Pivot table it showing more the 5 expressions like below:

So thats why I am clue less where I need to write. plz help me its very urgent..

Re: How to change color in Pivot table?

Gysbert_Wassenaar — Wed, 21 May 2014 11:55:00 GMT

It looks like you have four dimensions, not three and that you pivoted one dimension to horizontal layout. The result of that is that you get a column for each value of that horizontal dimension. You still have only one expression, not five. Perhaps you should simply try defining a background color expression for your chart expression and see what happens. Just try it and look at what happens. It's not as if you can break anything.

Re: How to change color in Pivot table?

soha1902 — Wed, 21 May 2014 12:02:03 GMT

Yes you are correct...we pivoted one dimensin to horizontal layout. How I will write plz give any idea.

I want

if (SW.Tag = PW.Tag)

then Pw.Tag: cell turns green

I wrote like under background color

if(SW.Tag=PW.Tag, Green())

But it showing error because SW.Tag and PW.Tag are directly not availabe bcz we pivoted it.

Please help...

Re: How to change color in Pivot table?

preminqlik — Wed, 21 May 2014 12:15:31 GMT

you need to write and condition like below

if(pivoteddimension='abc' and expression>3,green(),

if(pivoteddimension='uhu' and expression>4, red ,blue())

Re: How to change color in Pivot table?

soha1902 — Wed, 21 May 2014 12:48:11 GMT

Please any one help...its very urgent....

Re: How to change color in Pivot table?

mahesh_agrawal — Wed, 21 May 2014 13:49:25 GMT

Hi Soha,

Please find the attached QVW.

See the Background color attribute of Country dimension in the Dimension tab of chart.

Also see the Design grid's use by activating it.

You can change the expression's color from the Visual Cues Tab.

Re: How to change color in Pivot table?

Wed, 21 May 2014 13:54:58 GMT

Try this Expression Background color if(PivotDimension='Some',RGB(179,179,179),if(expression>5,RGB(59,59,59)))

Regards,

Chinni Kanna