Display an icon in Vizlib advanced Text object based on a condition

[Reko_freed]

I want to show a tick in vizlib advanced text object v1.7.12 if a column consists of a value say 'EXT.' else show cross (X)

what I have tried - if(col_name = 'EXT.', <p><i class = "fa fa-check"></p>, <p><i class = "fa fa-close"></p>)

but it's not working.

[Or]

col_name = 'EXT' will check if the only possible value in col_name is 'EXT'...

Have a look at this for checking if a value exists in a column:

https://community.qlik.com/t5/QlikView-App-Dev/Check-if-a-particular-value-is-present-in-a-field-s-l...

[Reko_freed]

Each and every value of that column should be 'EXT.' that is my condition

[Or · Accepted solution]

Does the if() part of your statement work? That is, if you replace the condition with 1=1 does the True aspect show and 1=0 the false aspect shows?

[Edit] Looks like at the very least you're missing the string quotes:

if(col_name = 'EXT.', '<p><i class = "fa fa-check"></p>', '<p><i class = "fa fa-close"></p>')

[Reko_freed]

Thanks @Or, it's now working

[Reko_freed]

@Or I have another question, could you please help, here's the link
https://community.qlik.com/t5/New-to-Qlik-Sense/Show-a-message-in-vizlib-advanced-text-object-when-a...