Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Vinod
Creator
Creator

How to Remove 0's

Hi All,

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

Thanks,

Vinod

Labels (1)
1 Solution

Accepted Solutions
Jacek
Creator
Creator

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])

View solution in original post

3 Replies
Jacek
Creator
Creator

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

Vinod
Creator
Creator
Author

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

Jacek
Creator
Creator

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])