topic Re: Avoiding textfields to be read as numbers in QlikView

Avoiding textfields to be read as numbers

Wed, 16 Jul 2014 15:08:17 GMT

I read from a view in Oracle database where a field has different VARCHAR values '4140' and '04140' however in QLIKVIEW both becomes '04140'. Is there a way to tell Qlikview it is two distinct values without change the values?

There are other values with just text, and they are OK.

If I add an 'a' in front of the values in the Oracle view, no leading zeros are added in Qlikview. So I take it has to do with Qlikviews in memory representation. But the field is a VARCHAR so adding a to_char() doesn't help.

Is there an option, setting or another way that could prevent this?

Re: Avoiding textfields to be read as numbers

maxgro — Wed, 16 Jul 2014 16:52:02 GMT

in my oracle it seems it works with text

load DEPTNO, text(DNAME), LOC;

sql select * from dept;

oracle

qlikview

Re: Avoiding textfields to be read as numbers

Thu, 17 Jul 2014 09:18:23 GMT

Thanks.

That does it.

My problem was that I only had

LOAD

Select * FROM ...;

The trick about LOAD <mention all fields with formatting>;

SELECT * FROM ...;

keeps the data right, however the load is no longer generic.