Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.