topic Re: colour cell other than custom/expression? help needed in QlikView

colour cell other than custom/expression? help needed

Tue, 07 Aug 2012 15:46:59 GMT

Hi all,

I have a pivot table with 2 horizontal dimensions and 1 vertical. I have used colour expressions and custom format cell but still have not been able to colour the large cell in top left corner of the table. is there some way to get round this as it really ruins the format of the table.

Thanks

Re: colour cell other than custom/expression? help needed

shree909 — Tue, 07 Aug 2012 15:51:47 GMT

I think by using Color format cell u can change the background color, if u have assigned to the dimenion or fact background color then the custom format wont allow you to change.

first remove all the background color from dimension and facts and use custom format cell to change the color.

Re: colour cell other than custom/expression? help needed

Tue, 07 Aug 2012 15:56:37 GMT

Thanks,

But i've tried using, both, and 1 or the other. It is just this cell that causes the issue, and it is only when the 3rd dimension is added.

Re: colour cell other than custom/expression? help needed

shree909 — Wed, 08 Aug 2012 01:57:08 GMT

can you provide an example so that it will be easy to identify the problem..

Re: colour cell other than custom/expression? help needed

rajni_batra — Wed, 08 Aug 2012 06:47:07 GMT

Post the Demo Application....