topic Re: Right, Left , Mid Functions ?? in QlikView

Right, Left , Mid Functions ??

ramcena306 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Right, Left , Mid Functions ??

mtucholski — Thu, 09 Aug 2018 07:15:03 GMT

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

where 'ID' is your field.

Re: Right, Left , Mid Functions ??

tresB — Thu, 09 Aug 2018 07:17:18 GMT

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

Re: Right, Left , Mid Functions ??

tamilarasu — Thu, 09 Aug 2018 07:22:43 GMT

Try this,

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

Re: Right, Left , Mid Functions ??

ramcena306 — Thu, 09 Aug 2018 07:23:13 GMT

Hi , Can you elaborate this Expression ?

Re: Right, Left , Mid Functions ??

mtucholski — Thu, 09 Aug 2018 07:29:36 GMT

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/StringFunctions/Len.htm

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