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.
Yes, my field valus have that format, but I´ve got, for eg. 00000120; 00120; 120, etc... All of that values refer to a product. But Qlikview is showing all products that end with 120. Discarting zeros from its calculations!