Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Right, Left , Mid Functions ??

Hi All,

I have a repair order column in my table which contains order like--000005054300,

From this i want a number without leading 0 and without last 4 digits. i want to do this in front end.

please help me.

jyothish8807qlikviewwizardstalwar1

Thanks,

Ramesh

5 Replies
Creator
Creator

=mid(ID,2,Len(ID)-5)

where 'ID' is your field.

MVP
MVP

= left(num( '000005054300'),Len(num( '000005054300'))-4)

Capture.JPG

Try this,

Num(Mid(FieldName,1,Len(FieldName)-4))

Creator
Creator

Hi , Can you elaborate this Expression ?

Creator
Creator

Hi,

it gets the string from second letter for number of letters in original string, minus 5 (because, we started with second letter and you do not want 4 last letters).

For details go to Qlik Help:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunction...

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/StringFunction...