Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
I check the db , its varchar
How to add 000 before in varchar in Qlikview script ?
Try it with:
right('0000000000' & [Client Facility Medical Record Number],10)
or maybe:
num([Client Facility Medical Record Number], '0000000000')
- Marcus