Solved: Display an icon in Vizlib advanced Text object bas... - Qlik Community

Reko_freed · ‎2022-12-01

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.', , )

but it's not working.

Or · ‎2022-12-01

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.', '', '')

Or · ‎2022-12-01

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:

Reko_freed · ‎2022-12-01

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

Or · ‎2022-12-01

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.', '', '')

Reko_freed · ‎2022-12-01

Thanks @Or, it's now working

Reko_freed · ‎2022-12-02

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