Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: Can a list box concatenate certain fields but not all

May be this:

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

mwoolf
Honored Contributor II

Re: Can a list box concatenate certain fields but not all

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

Community Browser