topic Re: Background colours of pivot table in QlikView

Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 09:06:57 GMT

HI,

I want to add background colours for below pivot table.

See attached image

Is it possible to do?

Re: Background colours of pivot table

Chanty4u — Tue, 01 Mar 2016 09:08:28 GMT

go to grid style....and right clik on table do select custom format cell and do the font and colur of ur fields

Re: Background colours of pivot table

Chanty4u — Tue, 01 Mar 2016 09:12:43 GMT

chk dis

Re: Background colours of pivot table

avinashelite — Tue, 01 Mar 2016 09:18:20 GMT

Try like this >

1.Go to User Preference in the document setting

2.Click on Grid option in the design tab

3.right click on the object >format cell

4.Here you will get all the option to change the color

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 09:27:04 GMT

Here i have use several dimensions and partial sums. That is why i coudn't get the colur variation. I have used custom format cell.

But can't seperate the raws

Re: Background colours of pivot table

Chanty4u — Tue, 01 Mar 2016 09:29:05 GMT

can u shre ur sample qvw?

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 09:29:09 GMT

I have marked that.

BUt no difference.

Here i have use several dimensions and partial sums. That is why i coudn't get the colur variation. I have used custom format cell.

But can't separate the raw

Re: Background colours of pivot table

avinashelite — Tue, 01 Mar 2016 09:34:10 GMT

Try like this :

Add this in the background colour area of the expressin, it will only format the total row

=if(rowno()=0 or isNull(rowno()),rgb(255,255,0),rgb(255,255,255))

Change the RGB() according to your required color format

Re: Background colours of pivot table

Chanty4u — Tue, 01 Mar 2016 09:37:17 GMT

chk dis

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 09:52:37 GMT

Qvw shared

Re: Background colours of pivot table

avinashelite — Tue, 01 Mar 2016 09:54:21 GMT

did you tried using my expression in the expression background color ??

Re: Background colours of pivot table

Chanty4u — Tue, 01 Mar 2016 09:58:08 GMT

is this?

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 10:08:23 GMT

Yes, it solve most of the case. only thing now i want is use light colr in my last right column

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 10:15:15 GMT

See attached

Re: Background colours of pivot table

avinashelite — Tue, 01 Mar 2016 10:21:42 GMT

try with the dimensionality() function

if(dimensionality() =0,yellow(),if(dimensionality() =1,grey(),rgb(255,255,255))

)

Re: Background colours of pivot table

vikasmahajan — Tue, 01 Mar 2016 10:21:47 GMT

Like This ?

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 11:23:48 GMT

Can you do it in attached qvw. It doesn't work for me

Re: Background colours of pivot table

vikasmahajan — Tue, 01 Mar 2016 11:28:39 GMT

PFA

Vikas

Re: Background colours of pivot table

anuradhaa — Tue, 01 Mar 2016 11:50:03 GMT

Finaly Did it with

=if(isNull(RowNo()),rgb(255,255,0),if(rowno()=0 and ColumnNo()<>0,rgb(255,155,100),if(ColumnNo()=0,Red(),rgb(225,225,225))))

AvinasheliteThank You for your Idea. You showed the way .

Re: Background colours of pivot table

avinashelite — Tue, 01 Mar 2016 12:08:12 GMT

Cool glad to hear that I was able to help you