Creating Groups Within a Single Variable

[#1]

My basic case is this:

I have a variable that shows the status or various projects. However, the formatting of the content of this variable is not consistent. For example, for a completed project, the responses are "Yes", "yes", "Closed", "Complete", "complete." Basically I want Qlikview to recognize all of these as one category "Completed."

Is there a way to do this?

[jonathandienst]

In a variable:

     Let vstatus = If(WildMatch(vstatus, 'yes', 'close*', 'complete*'), 'Completed', vstatus);

[#3]

This worked perfectly! Thank you!