Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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)