topic Case sensitive data in QlikView https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163285#M36441 <HTML><HEAD></HEAD><BODY><P>thank</P></BODY></HTML> Tue, 11 Jan 2011 12:17:58 GMT 2011-01-11T12:17:58Z Case sensitive data https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163281#M36437 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>I have a data column name city where we have citynames. This data table having the city names in different cases e.g. Delhi, delhi, DELHI. My qv selection field is treating this as three different citynames, I want to select all the data associated with city - Delhi.</P><P>How can I define to treat data irrespective of case sensitive</P><P></P><P>Thanks</P><P></P></BODY></HTML> Tue, 11 Jan 2011 11:41:35 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163281#M36437 2011-01-11T11:41:35Z Case sensitive data https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163282#M36438 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You can use capitalize(Cityname)</P><P></P><P>Anders</P></BODY></HTML> Tue, 11 Jan 2011 11:49:13 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163282#M36438 2011-01-11T11:49:13Z Case sensitive data https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163283#M36439 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use the string functions like Upper, Capitalize and Lower to convert in single String format at the script level.</P></BODY></HTML> Tue, 11 Jan 2011 11:56:23 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163283#M36439 2011-01-11T11:56:23Z Case sensitive data https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163284#M36440 <HTML><HEAD></HEAD><BODY><P>Thanks Anders</P></BODY></HTML> Tue, 11 Jan 2011 12:14:36 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163284#M36440 2011-01-11T12:14:36Z Case sensitive data https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163285#M36441 <HTML><HEAD></HEAD><BODY><P>thank</P></BODY></HTML> Tue, 11 Jan 2011 12:17:58 GMT https://community.qlik.com/t5/QlikView/Case-sensitive-data/m-p/163285#M36441 2011-01-11T12:17:58Z