topic Re: suppress or ignor extra 0 in QlikView

suppress or ignor extra 0

geam1988 — Sat, 11 Aug 2018 11:04:26 GMT

Hi, i am using MAKT.MATNR for material number.

material number are like this	Want to show like this
0000000081254	81254	from this type of number i want to remove extra 0 from left side and just want to show the value like this (81254)
0000000105857	105857
0000000105860	105860
856958	856958
MV00004586	MV00004586
MCDGGXT	MCDGGXT

sunny_talwar — Sat, 11 Aug 2018 11:07:51 GMT

Try this

Replace(LTrim(Replace(MAKT.MATNR, '0', ' ')), ' ', '0')

sunny_talwar — Sat, 11 Aug 2018 11:08:42 GMT

Sample script

Table:

LOAD Replace(LTrim(Replace(MAKT.MATNR, '0', ' ')), ' ', '0') as MAKT.MATNR;

LOAD * INLINE [

MAKT.MATNR

0000000081254

0000000105857

0000000105860

856958

MV00004586

MCDGGXT

];

or you can do this on the front end by just using this as a calculated dimension.

Replace(LTrim(Replace(MAKT.MATNR, '0', ' ')), ' ', '0')