topic Regarding Pivot Table in QlikView

Regarding Pivot Table

Tue, 23 Mar 2010 04:58:18 GMT

Hai,

This is regarding Pivot table. I have 100 records in the pivot table. I want to display each row/ Record in different color. Could someone help me on this?

Customer	Sales
Customer A	100
Customer B	200
Customer C	300
Customer D	400
Customer E	500
Customer F	600
Customer G	700
Customer H	800

Thanks in Advance.

Regarding Pivot Table

michael_anthony — Tue, 23 Mar 2010 11:55:59 GMT

Dimensions and Expressions have a Text Color function where you can control the color. Usually it's something like If(Var > 0,Red(),Green()) but can use the RGB(x,x,x) function to calculate colors.

In order to get different colors on each row, in the Text Color function use =Color(RowNo()). Color returns the color from the standard pallette based on an index. RowNo returns 1 - 100 for each row.