Character Limitation

[#1]

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.

Thanks..

[Gysbert_Wassenaar]

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.

[#3]

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.

[Gysbert_Wassenaar]

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?

...uhm... just to make sure, isn't it just the column width in the Qlikview chart object that needs to be increased?

[#5]

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.

DB: Buyer Poor Quality Price Adjustment

QV: Buyer Poor Quality P

If it was the column width you would get the proceeding "...."

Thanks

[Gysbert_Wassenaar · Accepted solution]

Interesting. But Qlikview does not limit field names to 18 characters. I just tested a field name of 310 characters.

What happens if you load the excel sheet? Do the field names get truncated then too?

[#7]

I didn't try that yet I will and let you know the outcome.

[its_anandrjs]

Hi,

Gysbert is right there is no limit related to the string in qlikview you have to try excel for particular file only.

Regards,

Anand

[#9]

Yep you were correct, it's an issue for the DB not Qlik.

Once again thanks for your help.