Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
In a variable:
Let vstatus = If(WildMatch(vstatus, 'yes', 'close*', 'complete*'), 'Completed', vstatus);
This worked perfectly! Thank you!