Problem with "right" function in script

[mgolinvaux]

Hello, i'm facing a strange bug with the "right" function in my script.

I wan't to get the last five characters in a string with letters and numbers (XX00000000 or more numbers) ,so i use this:

num(right(MYFIELD,5),'00000') as Field

The problem is when the string contain some "0", the function not works properly. The function get only characters before the "0", example:

DE60831584 -> 31584 -> correct

DE24708585 -> 8585 instead of 08585

DE0344700003 -> 0003 instead of 00003

It seems the function delete a "0" in the position 5.

When i'm using the function in a text box, that works perfectly (see attachment), i don't understand why this is not working in script.

We using QV 11.20 SR15.

Thank you for your help.

[Anil_Babu_Samineni]

I am not facing any issue. Using QV12.10

[devarasu07]

Hi,

I've tested in Qv 11.2 SR12 version and it's working fine. may be double check your end if the issue still exists try to raise ticket with Qlik support.  Thanks

[rwunderlich · Accepted solution]

Try adding a text() function to prevent QV from using number representation:

text(num(right(MYFIELD,5),'00000'))as Field

-Roob

[mgolinvaux]

Hello Rob,

Thank you for this, it works perfectly!

Have a nice day,

Regards.

[mgolinvaux]

Hello Devarasu,

Unfortunately, i don't wan't to change version of Qlikview on our serveur because it will cause some bugs, that's why we have changed to SR15 préviously.

Rob found a solution for me, thank you your answer by the way.

Regards.

[mgolinvaux]

Hello Anil,

Thank you for your asnwer but we can't change version of Qlikview actually, our serveur is not ready for a migration yet.

Regards.