Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Qlikview automatically adds '+0' to a field

Hello,

I am actually having an issue when Qlikview is reading a field from the database. The field being a partnumber (is alphanumeric in the database), and when read by the application it adds '+0' to some of the content of the field.

Example:

From the database, we might have values 1100345, 1104536,1230012, 1230014

When the data is read from QLikview, it could display +01100345, 1104536, +01230012, 1230014.

I have no idea under what circumstance it is adding the value '+0' in front of the actual value. Even if i add Text() on the field, it doesn't make any difference.

Could you please help?

Regards,

Selen

4 Replies
MVP & Luminary
MVP & Luminary

Try it with something like this:

load *, text(FIELD) as FIELD2;

sql select FIELD from db;

- Marcus

Contributor III
Contributor III

Hi Selena.

Please can you load the data (without any manipulation) and store it into a csv and post it here.

Thanks

Partner
Partner

Try -

Load *, NUM(FIELD) as FIELD2;

sql select FIELD from db;

MVP
MVP

Does this also happen if the LOAD of your part number from the DB is the one and only LOAD in your complete script?

If the part number field is already used in another LOAD statement appearing before the DB LOAD statement, then the textual representation of your part numbers might depend on the representation defined in the first LOAD. Qlik is only capable of storing a single representation per number.