Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=mid(ID,2,Len(ID)-5)
where 'ID' is your field.
= left(num( '000005054300'),Len(num( '000005054300'))-4)
Try this,
Num(Mid(FieldName,1,Len(FieldName)-4))
Hi , Can you elaborate this Expression ?
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: