Discussion board where members can get started with QlikView.
Membership field has value = 'NOT PROVIDED','LOW ENTRY', 'Gold','Diamond', 'Silver','Cooper',
I want to two value in one, like silver and cooper as silver and rest as usual , bellow is the syntax needed to be update
If(Upper([Membership])='NOT PROVIDED','LOW ENTRY',Upper([Membership])) as [Membership],
May be this?
If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName
View solution in original post