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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

List Box Expression

Hi Friends,

I'm having a field like TP_Type which having values POL, REN,END. I need to show these values as Policy , Renewal, Endorsement in list Box. How can i write an expression to achieve it.Please ,someone suggest to do it.

Thanks in Advance

Regards

Krishna

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

Pick(Match(TP_Type, 'POL', 'REN', 'END'), 'Policy', 'Renewal', 'Endorsement')

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

Pick(Match(TP_Type, 'POL', 'REN', 'END'), 'Policy', 'Renewal', 'Endorsement')

krishna20
Specialist II
Specialist II
Author

Thank you Tresesco.

Regards

Krishna