topic Re: leading zero using Len() in App Development

leading zero using Len()

wlpike — Thu, 02 Jul 2020 05:25:24 GMT

Hi,

i have an issue when importing data using ZIP codes from all over the world.

in the import script is want to identify the length of the zip codes using len().

It's working for almost every ZIP, but not for those that have leading zeroes. As it seems Len() is not recognizing a number (or a converted string) that begins with a zero.

the code i use is very easy:

Len(PLZ)

i tried that too:

Len(Text(PLZ))

e.g. when checking ZIP codes "01007" i get "4" in return (in both cases)

But what startled me is that when using the same code in the analysis area i get the correct length (5).

So why does it not work in the script area?

thanks

chris

Re: leading zero using Len()

Vegar — Thu, 02 Jul 2020 06:26:27 GMT

What you are telling us sounds like a big in my ears, Len() is a string function and I world expect it to return 5 in both your cases.

Im on vacation without access to try this myself, but if someone else are able to reproduce your error on the newest release of Qlik Sense then I suggest that you get in touch with Qlik Support in order to get it verified /registered as a bug.

A workaround could be something like this : Len('x' & text(PLZ) ) - 1 as Length

Re: leading zero using Len()

Saravanan_Desingh — Fri, 03 Jul 2020 03:00:56 GMT

Nice thought @Vegar . It's working.

Re: leading zero using Len()

wlpike — Thu, 09 Jul 2020 11:29:53 GMT

Hi @Vegar

thanks for this solution. On the first view its working, but it seems there is again a difference between using the code in load script or in analysis area.

Now for most of the zip codes i get the correct lenght, but for some of them not.

What puzzles me is that i get a different length for the same zip code. E.g. '0002'

sometimes i get "1" sometimes i get "4"

When i use your code in a chart table i alway get length "4".

do you know why this could happen?

Re: leading zero using Len()

arulsettu — Thu, 09 Jul 2020 11:52:28 GMT

Can you share sample data to reproduce the issue

Re: leading zero using Len()

wlpike — Thu, 09 Jul 2020 12:38:31 GMT

okay i think i have got it.

@Vegar your solution is absolutely correct. i get correct length for the zip code that (like descibed above) is actually "2" and not "0002". So what i find curious is that qlik shows me "0002" as zip code although in source file i have "2"

Raw data looks like this:

order_number;ticket;name;surname;E-Mail;country;state;address;zip_code

"2019-08-20 08:35:36";"mobile";"Jon";"Doe";"jd@yahoo.com";"IE";"Dublin";"Jon Doe Way";"2"

"2019-11-09 12:04:26";"mobile";"Artur";"Conan";"ac@gmail.com";"UK";"London";"buckingham palace";"0002"

so whats wrong is that my qlik table in analysis mode shows a totally wrong zip code ("0002" in both cases) and therefore length function used in analysis mode is wrong too...