Discussion Board for collaboration on QlikView Scripting.
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.
Solved! Go to Solution.
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
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.
Thank you for your asnwer but we can't change version of Qlikview actually, our serveur is not ready for a migration yet.