Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ramcena306
Creator II
Creator II

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
mtucholski
Creator
Creator

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

where 'ID' is your field.

tresesco
MVP
MVP

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

Capture.JPG

tamilarasu
Champion
Champion

Try this,

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

ramcena306
Creator II
Creator II
Author

Hi , Can you elaborate this Expression ?

mtucholski
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...