topic Re: Problem with "right" function in script in QlikView

Problem with "right" function in script

mgolinvaux — Mon, 06 Nov 2017 13:38:58 GMT

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.

Re: Problem with "right" function in script

Anil_Babu_Samineni — Mon, 06 Nov 2017 16:32:35 GMT

I am not facing any issue. Using QV12.10

Re: Problem with "right" function in script

devarasu07 — Tue, 07 Nov 2017 01:34:09 GMT

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

Re: Problem with "right" function in script

rwunderlich — Tue, 07 Nov 2017 02:25:26 GMT

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

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

-Roob

Re: Problem with "right" function in script

mgolinvaux — Tue, 07 Nov 2017 12:17:48 GMT

Hello Rob,

Thank you for this, it works perfectly!

Have a nice day,

Regards.

Re: Problem with "right" function in script

mgolinvaux — Tue, 07 Nov 2017 12:19:59 GMT

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.

Re: Problem with "right" function in script

mgolinvaux — Tue, 07 Nov 2017 12:20:59 GMT

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.