This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have a list of companies for example: google, Google, GOOGLE, google.com and I want all of these to be just Google.
If there a way that I can load a table into Qlikview and normalized the name using that table as a reference.
Such a table in my mind would be:
Normalized Name Name1 Name2 Name3 Name4
Google GOOGLE google google.com Google
you can't do case insensitive directly...but by using upper() or lower() for that matter and forcing all text values to one case for comparison purposes only, you can get around this.
as far as the wild mapping is concerned, try index() function.