topic Re: Length function in QlikView

Length function

Tue, 20 Sep 2011 08:08:54 GMT

Hi all

I'm missing the name for the function that in excel is called length. I have some article numbers that can be 7-8-9-10 digigts and I need to find out this by using this "length" function. Anybody that know the name in QV?

Best regards

Bjarne

Length function

its_anandrjs — Tue, 20 Sep 2011 08:15:08 GMT

Hi,

Use Len ( Field Name ) to find the length of the Field values

Rgds

Anand

Re: Length function

its_anandrjs — Tue, 20 Sep 2011 08:21:25 GMT

Hi,

See the attached sample file how touse

=Len( Value ) to get lenght in the columns

HTH

Rgds

Anand

Length function

Tue, 20 Sep 2011 08:40:28 GMT

Thank you Sir