Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Text to Symbol

I have around 5 symbols to be displayed with the INPUT provided in text from Excel to be displayed with resp symbols .

eg: A - to be displayed with

     B -

     C -

     D-

     E-

If statement will allow only maximum of 3 values.

Tried using Pick(match... but didn't work.

1 Solution

Accepted Solutions
senpradip007
Specialist III
Specialist III

Try like

Pick(Match([Your Field], 'A', 'B', 'C'), 'qmem://<bundled>/BuiltIn/smiley3.png', 'qmem://<bundled>/BuiltIn/smiley2_y.png',

'qmem://<bundled>/BuiltIn/smiley3_y.png' )

View solution in original post

3 Replies
senpradip007
Specialist III
Specialist III

Try like

Pick(Match([Your Field], 'A', 'B', 'C'), 'qmem://<bundled>/BuiltIn/smiley3.png', 'qmem://<bundled>/BuiltIn/smiley2_y.png',

'qmem://<bundled>/BuiltIn/smiley3_y.png' )

senpradip007
Specialist III
Specialist III

Have got your desire solution?

Not applicable
Author

Thank you Pradip Sen.