Colour on Pivot table

[Frédéricdh]

I made a pivot table with data from a SQL request:

This is the result:

And then I want to color the background of the Dimension ORT with diverse Color, but Qlik don't do it. It colors only the value 'sonstige Ort' and not the others. WHY?

Can anyone help me.

thanks a lot and in advance.

Best Regards

Frédéric

[Brian_C]

Hi

In the background color expression property under the dimension you can put an expression such as 

if(match(RowNo(),'1','3'),red(),green()) and this will set alternate rows to different colours.

I hope this helps you.

Brian

[Frédéricdh]

No it is not, what Im looking for.

But thx for the help

Frédéric

[Brian_C]

OK Can you explain a little more what your requirement is.

[Frédéricdh]

can we meet online?  With a visio coference?

[Frédéricdh]

I come back to you, when I have a visio prog.

thanks for the help

[Frédéricdh]

Hello Brian,

i don'r understand.

I have two pivot table.

One with this Function:

= if ( JW < (Year(addmonths(Today(1),-1) ) *100 + Week(addmonths(Today(1),-1))) + 1, '<= ' & (Year(addmonths(Today(1),-1,0) ) *100 + Week(addmonths(Today(1),-1,0))), If( JW <= (Year(addmonths(Today(1),1,0))*100 + Week(addmonths(Today(1),1,0))),JW))

And the background of the dimension is not properly colored

And the second with this Function:

= if (JW <= (Year(Today(1))*100 + Week(Today(1))), '<=' & (Year(Today(1))*100 + Week(Today(1))) )

and the background of th dimension is properly colored. Like I need

[Frédéricdh · Accepted solution]

I found the problem, it was in Presentation: Suppress Zero-Values. and now the background is colored. I don't understand why