background color and text color

[Anonymous]

Hi,

When you expand an expression and  put a background color och textcolor to it, it there anyway you can avoid the headline to be colored aswell?

Thanks!

[Anonymous]

Use the function RowNo() in the expression ... the header has no RowNo, the rows itself do have a rownumber > 0!!

rgrds,

Anita

[Anonymous]

Good idea! But ihave a pivot table and when they're collapsed none of the rows has a rowno...

[Anonymous]

e.g.:

if( rowno() = 0 or isnull(rownor()), HEADERCOLOR )

or

if( rowno() > 0, COLORROWS)

[Anonymous]

True ... that's why you should do the check with:

rowno() = 0

or

isnull(rowno())

grand total rows have a rowno() of null()

and pivot tables subtotal rows have a rowno() of 0

so check both values to be sure to got the correct interpretation

[Anonymous]

i added an expression to my tabel with just "rowno()" to check and first row after the healine has a row number of "0" så thats a problem. The oter rows (collapsed dimensions) har a "-" for row number.

[Anonymous]

rob wunderlich has also a sample of how the rowno() works in his cookbook ... maybe good to look at this

http://community.qlik.com/thread/29413

cookbook\layout\alternatetotalformat.qvw

rgrds,

Anita