topic Re: QV11 Text Color format not working in pivot table in QlikView

QV11 Text Color format not working in pivot table

Michael_Reese — Fri, 03 Aug 2012 17:08:28 GMT

I have a field for each color, R, G, B. These fields are attributes of dimesnions values. Each field value has it's own R, G and B components.

The text format is RGB(R,G,B).

This works fine in straight tables. In pivot tables, it only works with the dimension value in rows, not columns. I need columns.

I also tried custom format cells and the calculated condition keeps setting itself back to fixed.

Any alternatives?

Thanks

Anonymous — Fri, 03 Aug 2012 17:10:49 GMT

try chnaging it in visual cues

Michael_Reese — Fri, 03 Aug 2012 20:29:36 GMT

Unfortunately, I need to format the dimension value, not the expression.

jdf — Tue, 18 Sep 2012 22:40:36 GMT

I am running into this issue as well. Have you found a solution?

Thanks,

Jake

Michael_Reese — Mon, 15 Oct 2012 03:17:20 GMT

It shoud be fixed in SR2.

Mon, 22 Oct 2012 07:51:47 GMT

I am also stucked up with the same Issue. Even if we hard coded with a particular color, It is not working. Is there any solution for this

atafsson — Mon, 22 Oct 2012 08:10:30 GMT

You can Format cell, only aviable in Advanced Layout level. Then you format all the dimensions to the same color.

Activate Advanced Layout level under document properties. Right-click on the cell (on of the dimensions) and chose 'Format cell'.

You can do a calculated color with your fields RGB(R,G,B).

Hope it helps.