Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I have some data that has a Region and Market field. The problem is, sometimes it will be in all caps, and sometimes not. QlikView considers this a whole different thing.
So when I make a listbox just to show my Regions, I get:
MIDWEST
Midwest
NORTHEAST
Northeast
SOUTHEAST
Southeast
...and so on.
I want QV to consider MIDWEST the same as Midwest.
Any help please? Thank you.
Try
LOAD
...
capitalize( REGIONFIELD) as REGIONFIELD,
...
Sorry right after I posted my question I found a reasonable answer elsewhere (I swear I searched first but I wasn't entering the appropriate keywords the first time around).
Someone else suggested FORCE CASE UPPER before I load the field in question.
I am trying that now and it SEEMS to be working OK.
Thanks!