Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.