Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Champion III
Champion III

Hi,

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

Rgds

Anand

View solution in original post

3 Replies
its_anandrjs
Champion III
Champion III

Hi,

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

Rgds

Anand

its_anandrjs
Champion III
Champion III

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