Total columns pivot table / Colour

[#1]

Good afternoon,

as a designer, how could I put a general Sum at the botom of a pivot table?

If I have columns 2011 and 2012 for january, 2011 and 2012 for february, an so on, how could I colour the 2011 columns with one colour and the 2012 ones with other colour?

Thanks

Buenas tardes,

como se pone un total general a las columnas de una tabla pivotante?.

Si las columnas son 2011, 2012 para enero, 2011, 2012 para febrero, y así sucesivamente como puedo poner las columnas de 2011 de un color y las de 2012 de otro?

Gracias y saludos.

[whiteline]

Hi.

If you look at the expressions or dimensions tabs you can see '+' sign to the left of each name (dimension/expression).

If you click on it you will see 'Background color'.

Now you can enter an expression to color your cells.

For example, like this http://community.qlik.com/message/263393

[#3]

I've just wrote "=if(c_year=2011,RGB(100,200,255))" but the 2011 columns do not change its back groun colour, colud be somthing else?

[whiteline]

You can write just =RGB(100,200,255) to check whether you put it in the right place.

[#5]

Hi, is this the place you mean?, if so, something else must be wrong, in my PC maybe.

[#6]

Hi, is this the place you mean?, if so, something else must be wrong, in my PC maybe.

[#7]

Hi,

is this the place you mean?, if so, something else must be wrong, in my PC maybe.

[whiteline]

This should colorize the c_year values (the header).

I think you could try it in expression tab.

I thought you want to colorize the cells with values.

Anyway, you always can use simple expressions (=RGB(100,200,255) or =color(1)) just to check the effect.

[#9]

I do want to colorize the cells with values but I'm not able to do so neither to colorize the header.

Thank you very much any way.

[whiteline]

It's really strange.

You can try to create a clean qvw and play with it.