Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Max length of all fields

Hi,

Thought this was simple, but I'm struggling.

Here is the case:

* I have several fields in a QVdocument. 

* I have created a chart with a $field dimension

* How do I create an expression, that per "field", will show the maximum length (characters) of the content of the field.

I'd like a chart in the direction of this:

Name, MaxLength

==========================

NameField     5

AddressField     25

NextField     16

etc...

best regards

JF

4 Replies
Highlighted
Not applicable

hi,

Try the function Len() and Max().

Rebeca

Highlighted
Partner
Partner

Hi,

     This app can give you an idea.

Regards

Highlighted
Creator III
Creator III

Can we do it for n number of fields .. Say I have 140 fields.. My requirement is just to find the.. Maximum length of each fields.

 

The app you provided gives a good idea even i have tried the same, but we put valueloop instead of hard coded numbers it doesn't work . Any thoughts on this