Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

How I can remove leading zeroes

Hello, colleagues.I have a small problem, which I can't resolve elegant.

I want to remove leading zeroes from my Data.

I tried to do some text / num converting, but it didn't help me.

See attached file

31 Replies
Highlighted
Creator II
Creator II

Very nice. Thanks Rakesh.

Highlighted
Contributor III
Contributor III

awesome!!!!

Highlighted
Partner
Partner

Hi Anatoly,

Just one more possible solution for future readers...

num( EVALUATE(FieldToDeleteLeadingZeros),'#0') as MyNumber

Highlighted
Not applicable

I guess this is an old thread, but I remove leading zeroes by replacing them with blanks and then using ltrim on load like this:

replace(ltrim(replace(FIELDNAME,'0',' ')),' ','0')

It seems to work and is pretty elegant.

Highlighted
Not applicable

I use this formula:  replace(ltrim(replace(FIELDNAME,'0',' ')),' ','0')

and it seems to work.

Highlighted
Contributor
Contributor

Hi Rakesh,

Nice to see you here!. Was looking for a solution to this and found your answer, however I think this won't work for all scenarios.

If I have a material number: 00-001-002, this solution will return -001-002 therefore I enhance a little bit your already elegant solution:

if(purgechar(MATNR,' 0123456789') = '',replace(ltrim(replace(MATNR, '0', ' ')), ' ', 0),MATNR)

Regards,

Cesar

Highlighted
Contributor III
Contributor III

Thanks. This worked well for me

Highlighted
Partner
Partner

I use

num(num#(FieldName))

Highlighted
Partner
Partner

I use EVALUATE([FieldName] & '* 1') as replace(ltrim(replace(FIELDNAME,'0',' ')),' ','0') was also removing 0 inside the string, not just leading 0s

Specialist II
Specialist II

What on earth does that * 1 do?