Right, Left , Mid Functions ?? - Qlik Community

ramcena306 · ‎2018-08-09

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.

jyothish8807‌qlikviewwizard‌stalwar1‌

Thanks,

Ramesh

mtucholski · ‎2018-08-09

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

where 'ID' is your field.

tresesco · ‎2018-08-09

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

tamilarasu · ‎2018-08-09

Try this,

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

ramcena306 · ‎2018-08-09

Hi , Can you elaborate this Expression ?

mtucholski · ‎2018-08-09

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