Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Length function

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

1 Solution

Accepted Solutions
its_anandrjs

Hi,

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

Rgds

Anand

View solution in original post

3 Replies
its_anandrjs

Hi,

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

Rgds

Anand

its_anandrjs

Hi,

See the attached sample file how touse

=Len( Value ) to get lenght in the columns

HTH

Rgds

Anand

Not applicable
Author

Thank you Sir