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: 
Judicael
Partner - Contributor III
Partner - Contributor III

IF AND STATEMENT

Hello,

I have a field STATE with values : START , IN PROGRESS, ENDPOINT, COMPLETED, N/A

I want to transform the field STATE like START, IN PROGRESS, ENDPOINT, COMPLETED, N/A, MIXTE where MIXTE ={IN PROGRESS AND ENDPOINT}

 

ID, STATE_OLD, STATE_NEW

001, IN PROGRESS, MIXTE

001, ENDPOINT, MIXTE

 

Thanks for your help.

 

Regards.

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

As far i understand the question, You may need this?

If(Match(STATE, 'IN PROGRESS', 'ENDPOINT'), 'MIXTE', STATE) as New_Field

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

1 Reply
Anil_Babu_Samineni

As far i understand the question, You may need this?

If(Match(STATE, 'IN PROGRESS', 'ENDPOINT'), 'MIXTE', STATE) as New_Field

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)