topic Re: Conditionally format a dimension in QlikView

Conditionally format a dimension

salto — Thu, 25 Sep 2014 05:04:20 GMT

Hello,

I have a chart, with a single dimension, in which I would like to conditionally format the dimension column.

The condition is: If the two right characters of the dimension (named Node) are '00', it should be BOLD. Otherwise, normal characters.

Where (and how) should I write this condition?

Many thanks in advance!

PrashantSangle — Thu, 25 Sep 2014 05:13:05 GMT

Hi,

Select that dimension,

Click on + symbol write expression in Text Format

Expression like

if(wildmatch(right(Node,2),'00',<B>)

Regards

jonathandienst — Thu, 25 Sep 2014 05:15:01 GMT

Click the + sign next to the dimension (in the Dimension tab of the chart properties), select Text Format, and add the expression:

=If(Right(Node, 2) = '00', '<B>')

HTH

Jonathan