topic Color within Dimension in QlikView

Color within Dimension

Fri, 26 Mar 2010 15:17:25 GMT

If I have a Dimension, let´s say Account

Account = (Revenues,Costs, Ebitda,NetIncome)

How can I make EBITDA black and bold within the Dimension in a Pivot Table ???

Appreciate the help

Color within Dimension

Fri, 26 Mar 2010 15:19:37 GMT

I think you can do it by chart properties --> Visual Cues --> select the expression and select Bold checkbox..

You can also add calculated font color expression in dimension and expressions...

Color within Dimension

Fri, 26 Mar 2010 15:29:33 GMT

Thanks for your reply,

My question is how to do it in a dimension, I run out of ideas. I would appreciate if you can guide me through

Thanks

Color within Dimension

Fri, 26 Mar 2010 15:47:35 GMT

Hi,

In your table properties, expand the dimension "account" and edit the "Text Format". In order to have the Ebitda Account displayed as bold just write this kind of code:

=if(Account='Ebitda', '<B>')

Color within Dimension

Fri, 26 Mar 2010 15:54:34 GMT

Thanks a lot man, It worked perfectly.