Pivot table as Cross Table and alternate color

[bluecarbon]

Hi All,

I m trying to have alternate coloring in Pivot table which is converted as crosstable. The expr if(Even(RowNo(Total)),rgb()) works fine if I dont have a column at top, but when I add a column top of the pivot table(Cross Table) I m not getting alternate colors.

Please let me know if there is any way to have alternate coloring in Qlikview Pivot chart as Cross Table

Thanks,

Rakul

[priyasawant]

can you share the data or screen shot of the same

[dsharmaqv]

try this

How to alternate dimension's colour on pivot tables

hope it helps

[bluecarbon]

Hi,

I need alternate color for the entire row of each country.

[vishsaggi]

Did you try this background color expression in your expression background. Like

Dim background and expression background.

Or did you try in Pivot table properties Style tab and CurrentStyle by changing the style?

Can you share a sample app to look into?