topic Re: Creating Groups Within a Single Variable in QlikView

Creating Groups Within a Single Variable

Thu, 02 Jul 2015 14:10:21 GMT

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?

Re: Creating Groups Within a Single Variable

jonathandienst — Thu, 02 Jul 2015 14:16:59 GMT

In a variable:

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

Re: Creating Groups Within a Single Variable

Wed, 08 Jul 2015 14:28:56 GMT

This worked perfectly! Thank you!