topic How to format a Pivot Table column based on a dimension in QlikView

How to format a Pivot Table column based on a dimension

Wed, 11 Aug 2010 00:39:43 GMT

Hi there,

Anybody know how to set a bold format to a text in a pivot table column based on a dimension. I'm traying to do it using a expression but I haven't found out yet how I could do it.

Thanks for your help.

r.m.

How to format a Pivot Table column based on a dimension

johnw — Wed, 11 Aug 2010 00:51:10 GMT

For the text format for your dimension, enter something like this:

=if(Employee='Bob','<b>')

How to format a Pivot Table column based on a dimension

Thu, 12 Aug 2010 16:42:44 GMT

Thank you John.

I have another question. How could you set format (to the background or to the text) to a column header based on a expression and a dimension.

Thanks again.

How to format a Pivot Table column based on a dimension

johnw — Thu, 12 Aug 2010 18:27:39 GMT

If I understand the question, I don't think you can do it. The column header picks up the formatting from the first row of the table when you use expressions to control formatting. I consider that a poor design decision on the part of the developers, but that's what we're stuck with for now.