Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Avoiding textfields to be read as numbers

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?

1 Solution

Accepted Solutions
maxgro
MVP
MVP

in my oracle it seems it works with text

load DEPTNO, text(DNAME), LOC;

sql select * from dept;

oracle

1.png

qlikview

11.png

View solution in original post

2 Replies
maxgro
MVP
MVP

in my oracle it seems it works with text

load DEPTNO, text(DNAME), LOC;

sql select * from dept;

oracle

1.png

qlikview

11.png

Not applicable
Author

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.