topic Re: Backgroundcolor in Pivot Tble in QlikView

Backgroundcolor in Pivot Tble

kris_vliegen — Thu, 17 Oct 2013 09:28:59 GMT

Hi all,

I have a pivot table like this.

Can I change the backgroundcolor per station or per line?

So it's more clear to read this?

I was thinking in the backgroundproperties like : =if( even(RowNo( ))= 'true', darkgray( ) )

But this doesn't work.

tresB — Thu, 17 Oct 2013 09:36:13 GMT

For expression column, you can try like:

=if( even(RowNo( )), darkgray( ) ) // without 'true'

if it's a dimension column, rowno() would not work, alternatively you can check dimension member(or, some other logic) and put color accordingly.

vikasmahajan — Thu, 17 Oct 2013 09:40:55 GMT

Right Click - > Properties -> Expression -> Background color ->

Give condition

=if(column(3)>0.001 and column(2)>0.001,if(column(3)>column(2),rgb(0,182,0),rgb(247,247,247)),0)

ngulliver — Thu, 17 Oct 2013 09:44:35 GMT

Hi, Kris.

You have several options here.

If you want to simply highlight the rows better, go to Style tab, change current style to Light and have stripes every other line.

If you want to highlight good and bad values I often use the expression below in the background colour or the 'Visual Clues' tab

=IF(Field1 > 0,

$(vColTrafficGreen),

IF(Field1 < 0,

$(vColTrafficRed),

$(vColTrafficGreen)

))

with the variables being predefined rgb,

Regards,

Neil

kris_vliegen — Thu, 17 Oct 2013 09:50:40 GMT

Hi Neil,

I would like to simply highlight the rows better but if I go to the style Light I can't change the number of stripes???

I also tried with borders above spacing. This is working in my client version, but not if I contact the documnet with chrome.

kris_vliegen — Thu, 17 Oct 2013 09:58:01 GMT

Hi Vikas,

If I do this I get

kris_vliegen — Thu, 17 Oct 2013 11:16:27 GMT

This isn't working for my Pivot-table.

Regards,

Kris