chart color, alternate in rows

[#1]

i want to fill table chart with alternate color in rows.

row1 - green

row2- blue

row3- green

row4- blue

i have enable the setting from user preferences  - > design -> always show design menu

in custom format cell - background color i expression is

if(mod(RowNo(total),2)=0,green(),blue())

but it is not working

[#2]

ok... one question is ..

i have the same setting in my qlikview that is installed on my machine and save the document with same setting.

now if any other user open same document on other machine and he has not enable the same setting .. is he able to see all this color changes??

[its_anandrjs]

Yes he can view same settings even the tab that you open last and close there it is view to the other also. And if the application is view from QV access point no one can able to change any settings.

Regards

Anand

[#4]

thanks all of you

[KPL69]

Hi Anand

How do you do the alternating colour for an the entire row based on the change of a particular field value?