Problem Qlikview Leading 0 in dataset

[#1]

Hello alltogether. I have a problem with the leading 0 in a dataset.

I have the items "6" and "06". While importing, qlikview convertes the "6" into "06". So now I have two items "06".

For item "5" nothing happens, because we don't have the item "05".

If I insert into database the item "05" the same happens, that I have the item "05" twice.

Is this a known problem. What can I do with it?

Thanks for your answer.

Regards CH

[#2 · Accepted solution]

How are you doing the load? I've seen questions about QlikView automatically removing leading zeroes, but never heard of it adding them.

Try:

Load text(FIELD) As FIELD

Here's a recent thread on using text to retain leading zeroes: http://community.qlik.com/forums/t/18052.aspx

[#3]

Hi,

I'd agreed with that - I had the problem of leading zeros vanishing but never them appearing! Definitely try the text(FIELD) AS FIELD option. That's worked for me. Word to the wise though - not sure if this will affect you. If you then want to export to Excel any with leading zeros will retain the text format but just numeric values probably won't. Not sure if this bug has been fixed in V9 (I'm currently with V8.5).

Cheers,

Emma

[#4]

Thank you you both. That works fine.

Perfect !!