topic Re: Column Background color in pivot table in QlikView

Column Background color in pivot table

brindlogcool — Thu, 28 Mar 2013 09:46:29 GMT

Hi ,

I am trying to add the background color in the pivot table based on the column value using the if else condition

If(Time='WTD',ARGB(255,132,189,0),
If(Time='MTD',ARGB(199,132,189,0),
ARGB

(130,132,189,0)))

it is working fine when it is at the column , but when it is dragged to a row it is not working.

Is there any workaround or is it a bug?

Re: Column Background color in pivot table

Thu, 28 Mar 2013 11:15:42 GMT

Maybe the problem is the Time value when this dimension is moved to rows. Depending on how you place the columns and rows, you could have more than one value for Time. Try with Max(Time) = ...

Re: Column Background color in pivot table

brindlogcool — Thu, 28 Mar 2013 13:48:45 GMT

Thanks for your response. I tried Max but it is not working.

Re: Column Background color in pivot table

Thu, 28 Mar 2013 14:15:43 GMT

Hai

brinlogcol, If you want to give colours to your rows , you can go to the visual cues and give the condition

values greater than or less than.you can also give the condition of your own also.

hope it helps.

Regards,

Ramesh

Re: Column Background color in pivot table

brindlogcool — Sun, 31 Mar 2013 02:27:58 GMT

Thanks,

Visual cues is different. I dont think you can use visual cues for coloum header.

Re: Column Background color in pivot table

neha_shirsath — Mon, 01 Apr 2013 09:36:13 GMT

Hi brindlogcool,

You want to change backgorund color of only header in Pivot table?

Try this,

Right click on table and select the Custom format cell and you can change the color here.

Regards,

Neha

Re: Column Background color in pivot table

sushil353 — Mon, 01 Apr 2013 10:17:46 GMT

Hi,

Is this what you are looking for..

please find attached

HTH

Sushil

Re: Column Background color in pivot table

ChristofSchwarz — Wed, 12 Jun 2013 20:24:03 GMT

I don't have "Custom format cell" in my context menu when I right-click on a Pivot-Chart. Did you have to set something on Document level or Desktop Client Level in order to get into that advanced feature?

Re: Column Background color in pivot table

Anonymous — Wed, 12 Jun 2013 20:29:31 GMT

To get "custom format cells" in the pop-up menu, you first have to show grid
(Don't ask me why...)

Regards,

Michael