topic Re: How to Remove 0's in QlikView

How to Remove 0's

Vinod — Sat, 16 Nov 2024 04:41:54 GMT

Hi All,

How to remove zero's after GR008JP02A and keep the last numbers.

Thanks,

Vinod

Re: How to Remove 0's

Jacek — Tue, 22 Jan 2019 11:43:33 GMT

=left( [Branch Code], 10) & Num( right( [Branch Code], 5))

Re: How to Remove 0's

Vinod — Tue, 22 Jan 2019 12:05:29 GMT

Particularly for this Code-GR008JP02A , I wan't the result. and Upper Expression is not working also.

Re: How to Remove 0's

Jacek — Tue, 22 Jan 2019 12:27:57 GMT

I see that only for this code you want to apply change. Right? Just add if :

if( left( [Branch Code], 10) = 'GR008JP02A' , 'GR008JP02A' & Num( right( [Branch Code], 5)), [Branch Code])