topic Re: leading zero's not working .? in QlikView

leading zero's not working .?

ashmitp869 — Thu, 28 Apr 2022 02:35:41 GMT

Hi ,

What is wrong in my script with the leading zero's

Qlikview script :

MRN Pool HERO ID]&' '& right('0000000000'+[Client Facility Medical Record Number],10) as [MRN Pool HERO Id MRN]

But the end result is not showing zero's

Please suggest ?

ashmitp869 — Thu, 28 Apr 2022 03:01:08 GMT

I check the db , its varchar

How to add 000 before in varchar in Qlikview script ?

marcus_sommer — Thu, 28 Apr 2022 06:26:54 GMT

Try it with:

right('0000000000' & [Client Facility Medical Record Number],10)

or maybe:

num([Client Facility Medical Record Number], '0000000000')

- Marcus