Text formatting: set in bold fields that "ends" or "contains"...

[#1]

Hi everyone!

I am trying to set in bold a dimension that ends or contains the word "Global", however it does not work.

I have a bar graph with only one dimension and expresion and I want to set in bold the ones that ends with "Global", so in the dimension and text format i wrote the following:

=if(level2='*Global','<B>')

it does not work, however if I writte a complete field, instead of the ones that "ends with", it works perfectly.

=if(level2='Casa Global','<B>')

can someone help me with this matter?¿

thank you so much!

[sunny_talwar]

Try this:

If(WildMatch(level2, '*Global', '<b>')

or

If(level2 Like '*Global', '<b>')

or

If(Index(level2, 'Global'), '<b>')

[agustinbobba]

Hi,

Try to use WildMatch function

HOW TO USE IF & WILDMATCH TOGETHER ? | Qlik Community

Regards,

Agustin.

[#4]

thank you both for the help, however it only works if my data is in a table and not in a graph.

i use the same dimensions, the same expresion evrything is the same but it only works with a table....

Can any of you explain to me why?

thank you all

😃