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

Announcements
Join us in Zurich on Sept 24th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can a list box concatenate certain fields but not all

Hi,

I basically have a list box that has people titles in them.

Mr

Master

Miss

Mrs

Ms

Is it possible for me to concatenate say Mrs + Ms together so my list looks like this:

Mr

Master

Miss

Mrs/Ms

I know you can use an expression as the field, but i just don't know the syntax to achieve what i am trying to

2 Replies
sunny_talwar

May be this:

If(Match(FieldName, 'Mrs', 'Ms'), 'Mrs/Ms', FieldName)

m_woolf
Master II
Master II

=if(Title='Mrs' or Title = 'Ms','Mrs/Ms',Title)