topic Loading a data field that is sometimes all upper-case, sometimes not? in QlikView https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412441#M1157377 <HTML><HEAD></HEAD><BODY><P>Hello. I have some data that has a <STRONG>Region</STRONG> and <STRONG>Market</STRONG> field. The problem is, sometimes it will be in all caps, and sometimes not. QlikView considers this a whole different thing. </P><P></P><P>So when I make a listbox just to show my Regions, I get:</P><P></P><P>MIDWEST</P><P>Midwest</P><P>NORTHEAST</P><P>Northeast</P><P>SOUTHEAST</P><P>Southeast</P><P></P><P>...and so on.</P><P></P><P>I want QV to consider MIDWEST the same as Midwest.</P><P></P><P>Any help please? Thank you.</P></BODY></HTML> Thu, 10 Jan 2013 18:28:29 GMT 2013-01-10T18:28:29Z Loading a data field that is sometimes all upper-case, sometimes not? https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412441#M1157377 <HTML><HEAD></HEAD><BODY><P>Hello. I have some data that has a <STRONG>Region</STRONG> and <STRONG>Market</STRONG> field. The problem is, sometimes it will be in all caps, and sometimes not. QlikView considers this a whole different thing. </P><P></P><P>So when I make a listbox just to show my Regions, I get:</P><P></P><P>MIDWEST</P><P>Midwest</P><P>NORTHEAST</P><P>Northeast</P><P>SOUTHEAST</P><P>Southeast</P><P></P><P>...and so on.</P><P></P><P>I want QV to consider MIDWEST the same as Midwest.</P><P></P><P>Any help please? Thank you.</P></BODY></HTML> Thu, 10 Jan 2013 18:28:29 GMT https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412441#M1157377 2013-01-10T18:28:29Z Re: Loading a data field that is sometimes all upper-case, sometimes not? https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412442#M1157378 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>LOAD</P><P>...</P><P>capitalize( REGIONFIELD) as REGIONFIELD,</P><P>...</P></BODY></HTML> Thu, 10 Jan 2013 18:36:11 GMT https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412442#M1157378 swuehl 2013-01-10T18:36:11Z Re: Loading a data field that is sometimes all upper-case, sometimes not? https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412443#M1157379 <HTML><HEAD></HEAD><BODY><P>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).</P><P></P><P>Someone else suggested FORCE CASE UPPER before I load the field in question.</P><P></P><P>I am trying that now and it SEEMS to be working OK.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 10 Jan 2013 18:38:00 GMT https://community.qlik.com/t5/QlikView/Loading-a-data-field-that-is-sometimes-all-upper-case-sometimes/m-p/412443#M1157379 2013-01-10T18:38:00Z