topic Re: Leading zeroes get vanished in QlikView

Leading zeroes get vanished

QV_learner — Sat, 16 Nov 2024 03:05:10 GMT

Hello Friends,

I am working on one application. In this, I extract data from SQL and store it into QVD. Now, I use this QVD to extract data into main application. But, when I load the data, for some values, the leading zeroes are vanished.

As a part of solution, I tried using text(); but this makes only few of the records to show leading zeroes and for rest of others, the leading zeroes are vanished.

Could you please help me understand this issue and resolve it?

Thank You!

Re: Leading zeroes get vanished

hectormunoz — Fri, 05 Jul 2019 14:33:42 GMT

if you know the lenght of the field you can use

text(num(field,'00000'))

so every value will have 5 positions

Regards

Re: Leading zeroes get vanished

QV_learner — Mon, 08 Jul 2019 13:26:31 GMT

The field I am using has data type as 'Text'; sorry I didn't mention it earlier.

Re: Leading zeroes get vanished

atoz1158 — Mon, 08 Jul 2019 15:32:44 GMT

You could try using the following just adjust it for what you need

RIGHT('00000' & field,5)

So this will give

Field Result

45 00045

0675 00675

HTH

Adrian

Re: Leading zeroes get vanished

Vegar — Mon, 08 Jul 2019 15:56:42 GMT

It's probably enough to wrap text around the field when loading

Load

Text(FieldName) as FieldName

;

SQL SELECT

FieldName,

...

FROM DATABASE;

Re: Leading zeroes get vanished

Brett_Bleess — Wed, 31 Jul 2019 13:00:52 GMT

Just to add to Vegar's post, the real question is whether the issue is in the backend in your DB, or on the ETL into QlikView? Potentially, there may be something going on in the ODBC/OLE DB driver you are using to connect to the DB source as well, so if things are not making sense on our side, have a look on the DB vendor forums related to the Connector/Driver you are using etc. to see if you can find any known issues with it.

Regards,
Brett

Re: Leading zeroes get vanished

QV_learner — Fri, 09 Aug 2019 12:02:32 GMT

Thank you guys, for the answers.
I tried every one of them; but no luck.
Let me go with DB search option suggested by Brett, hope it will get some answer.

Once again, Thank You All!

Re: Leading zeroes get vanished

Brett_Bleess — Mon, 12 Aug 2019 13:36:54 GMT

Hey Vivek, if you get further info, feel free to come back and post an update, and we can see if we can come up with anything else at that point...

Cheers,
Brett