Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Why zeros are added at start

i have different form of medical Numbers ( '2226' , 'MQ234' )

But when i do a concat code such as   Id & '-' & [Medical Number]  the format i receive for the ones 2226 is  0000 2226

how can i make it not do that ???

13 Replies
its_anandrjs

Use like

Trim(id) & '-' & [Medical Number]

if you have sample in excel then provide.

and also check that your field id contains only 2226  not 0000 2226 in the field.

Not applicable
Author

post some sample data..

fkeuroglian
Partner - Master
Partner - Master

Hi

try this

REPLACE(LTRIM(REPLACE([Medical Number], '0', ' ')), ' ', '0')as [Medical Number],

Good luck

Fernando

sunilkumarqv
Specialist II
Specialist II

Mixed of  string and int better to be use Dual Function


dual( 'Id' , 'Medical Number' ) AS YouField

rajat2392
Partner - Creator III
Partner - Creator III

use the below code

concat([Medical Number] ,'-')

Not applicable
Author

DEar All Iam getting the following table

Medical Record NO.FilterID
mq009371787708-mq00937178-01.17.2013
mq009492917708-mq00949291-01.23.2013
mq009690697708-mq00969069-12.19.2012
MQ009691067708-MQ00969106-12.19.2012
MQ009693097708-MQ00969309-12.20.2012
5097708-00000509-04.25.2013
5097708-00000509-06.20.2013
5987708-00000598-03.20.2013
6027708-00000602-04.25.2013

where i use in the script the following formula


LocationID & '-' & [Medical Record No. :] & '-' & Date as FilterID,



I tried all the solutions mentioned but didnt get

mambi
Creator III
Creator III

can you provide us a sample data !

maxgro
MVP
MVP

try with

LocationID & '-' & text([Medical Record No. :]) & '-' & Date as FilterID,


its_anandrjs

If medical record no which is 00000509 and so with same length like 8 then use below code to make it NUM and then use in the script

LocationID & '-' & [Medical Record No. :] & '-' & Date as FilterID,

Try This

if(len([Medical Record NO.])=8,Num([Medical Record NO.]),[Medical Record NO.]) as [Medical Record NO.]