Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

text format of a part of a string

I have string fields like: 

'Booking hotel ABC'

'13-02-2020 Diner Restaurant'

'Soccermatch 123'

With this formula: 

If(wildmatch(FIELD,'*Hotel*', '*Diner*'), FIELD, nul())

I select the first and the second line with this formula. 

I want to change the color of the font of the part of the string that was matched..


'Booking hotel ABC'

'13-02-2020 Diner Restaurant'

Is this possible in Qlik? 

Labels (2)
1 Reply

Coloring of a part of a string is not possible natively in qlik, afaik. You could break the strings down into multiple fields and color them as necessary and join them back as a single string in the UI. However, there could be extension (not sure though) you might want to explore in qlik branch.