Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

two value combined in field ,

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],

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: two value combined in field ,

May be this?

If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName

View solution in original post

1 Reply
Highlighted

Re: two value combined in field ,

May be this?

If(Match(Upper(Membership), 'SILVER', 'COOPER'), 'silver', 'usual') as NewFieldName

View solution in original post