15 Replies Latest reply: Aug 29, 2014 5:34 AM by Bruno Silva RSS

    Zero at left are being discarted

    Bruno Silva

      Hello.

       

      I´m having a problem.

      One field of my table has Zeros at left side and althought I´m using "text(myfield) as myfield" in script, Qlikview keeps processing it without the zeros. Eg: Myfield = 00000120. Qlikview show it just like that, with the 5 zeros, but at processing level it does show all article where Myfield end with 120.

      Any ideas?

       

      Thanks in advance,

      Best Regards,

      BS.