topic Re: Character Limitation in QlikView https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677819#M1053839 <HTML><HEAD></HEAD><BODY><P>They use the same ODBC driver, and nope not the column width. Here is an example of the data in the DB and another being displayed in Qlik.</P><P></P><P>DB: Buyer Poor Quality Price Adjustment</P><P>QV: Buyer Poor Quality P</P><P></P><P>If it was the column width you would get the proceeding "...."</P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 Oct 2014 12:31:38 GMT 2014-10-22T12:31:38Z Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677815#M1053835 <HTML><HEAD></HEAD><BODY><P>Is there a way to extend the 18 character limit for a Dimension? I have a Dimension that is a text string from an external DB and Qlik is truncating the text string and limiting it to only 18 characters.</P><P></P><P>Thanks.. </P></BODY></HTML> Wed, 22 Oct 2014 12:11:24 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677815#M1053835 2014-10-22T12:11:24Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677816#M1053836 <HTML><HEAD></HEAD><BODY><P>That sounds like a limitation of the odbc or oledb driver you're using to get the data from your source database. It's not a limitation of Qlikview. Field names and field values can be longer than 18 characters.</P></BODY></HTML> Wed, 22 Oct 2014 12:15:35 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677816#M1053836 Gysbert_Wassenaar 2014-10-22T12:15:35Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677817#M1053837 <HTML><HEAD></HEAD><BODY><P>That's what I original thought, but if I extract it into Excel I get the whole string. It is only when I pull it into Qlik that it truncates the string.</P></BODY></HTML> Wed, 22 Oct 2014 12:18:36 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677817#M1053837 2014-10-22T12:18:36Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677818#M1053838 <HTML><HEAD></HEAD><BODY><P>What tool are you using to extract the data to excel? Is that tool using the same odbc/oledb driver that is Qlikview is using? </P><P></P><P>...uhm... just to make sure, isn't it just the column width in the Qlikview chart object that needs to be increased?</P></BODY></HTML> Wed, 22 Oct 2014 12:24:26 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677818#M1053838 Gysbert_Wassenaar 2014-10-22T12:24:26Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677819#M1053839 <HTML><HEAD></HEAD><BODY><P>They use the same ODBC driver, and nope not the column width. Here is an example of the data in the DB and another being displayed in Qlik.</P><P></P><P>DB: Buyer Poor Quality Price Adjustment</P><P>QV: Buyer Poor Quality P</P><P></P><P>If it was the column width you would get the proceeding "...."</P><P></P><P>Thanks</P></BODY></HTML> Wed, 22 Oct 2014 12:31:38 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677819#M1053839 2014-10-22T12:31:38Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677820#M1053840 <HTML><HEAD></HEAD><BODY><P>Interesting. But Qlikview does not limit field names to 18 characters. I just tested a field name of 310 characters.</P><P>What happens if you load the excel sheet? Do the field names get truncated then too?</P></BODY></HTML> Wed, 22 Oct 2014 12:40:01 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677820#M1053840 Gysbert_Wassenaar 2014-10-22T12:40:01Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677821#M1053841 <HTML><HEAD></HEAD><BODY><P>I didn't try that yet I will and let you know the outcome.</P></BODY></HTML> Wed, 22 Oct 2014 12:45:20 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677821#M1053841 2014-10-22T12:45:20Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677822#M1053842 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Gysbert is right there is no limit related to the string in qlikview you have to try excel for particular file only.</P><P></P><P>Regards,</P><P>Anand</P></BODY></HTML> Wed, 22 Oct 2014 12:47:52 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677822#M1053842 its_anandrjs 2014-10-22T12:47:52Z Re: Character Limitation https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677823#M1053843 <HTML><HEAD></HEAD><BODY><P>Yep you were correct, it's an issue for the DB not Qlik.</P><P></P><P>Once again thanks for your help.</P></BODY></HTML> Wed, 22 Oct 2014 13:12:22 GMT https://community.qlik.com/t5/QlikView/Character-Limitation/m-p/677823#M1053843 2014-10-22T13:12:22Z