Different colour of lines in pivot tables

[#1]

Hello All,

I usually use this expression to make 1 line white and 1 line grey in my normal table:

=if(mod(rowno(TOTAL), 2) = 1,  white(), rgb(212,212,212))

However, it is not working in a pivot table.

Any idea why I do not get the same result on my pivot table.

Many Thanks,

Hasvine

[qlikviewwizard]

‌hi,

please check this link also. Thank you.

How to show colors in report or chart

[parispantelis]

Hi,

i  had a pivot like this

                                     dimentions here

---------------------------------------------------------------------------------

expression1                    data                    data

epression 2                    data                    data

i had to place instead of RowNo -> ColumnNo in every expression to have these tow colors in chart:

if(Dimensionality()> 0,
if(mod(ColumnNo(TOTAL), 2) = 1,  white(), rgb(212,212,212))
)

[#4]

Hi,

Go through the below link it might help you.

how to make unique color