topic Re: background colour in QlikView

background colour

Anonymous — Sun, 06 Sep 2015 10:22:26 GMT

Hi,

I'd like to define a specific background colour for the total Column of a pivot table (see the file attached). How can I do it?

Thank you in advance,

Larisa

Re: background colour

Anonymous — Sun, 06 Sep 2015 10:26:39 GMT

hi,

goto expression tab - expand expression (click +) - background - give =rgb(255,255,0)

Re: background colour

Anonymous — Sun, 06 Sep 2015 10:34:55 GMT

Yes, I know about this possibility. But what I mean is a bit different.

I wat to set a certian colour for Total column ONLY, but not for the whole expression.

Re: background colour

petter — Sun, 06 Sep 2015 10:41:25 GMT

You can test for being in the Total Column (which programatically could be the Row if you have moved the dimension around in your pivot) by doing this:

(the expession for the background color)

If( RowNo() = 0 , Yellow() )

Re: background colour

Anonymous — Sun, 06 Sep 2015 10:46:39 GMT

hi,

please try:

if(fieldname ={value},rgb(255,255,0))

If( RowNo() = {value}, rgb(255,255,0) )

Re: background colour

Anonymous — Sun, 06 Sep 2015 10:49:20 GMT

Thank you!