Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
salto
Specialist II
Specialist II

Conditionally format a dimension

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!

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

2 Replies
PrashantSangle

Hi,

Select that dimension,

Click on + symbol write expression in Text Format

Expression like

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein