Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Lars_Esser
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..

So: 

'Booking hotel ABC'

'13-02-2020 Diner Restaurant'

Is this possible in Qlik? 

Labels (1)
1 Reply
tresesco
MVP
MVP

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.