Max length of all fields

[johanfo2]

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

[#2]

hi,

Try the function Len() and Max().

Rebeca

[prodanov]

Hi,

     This app can give you an idea.

Regards

[raajaswin]

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

[raajaswin]

https://community.qlik.com/t5/QlikView-App-Development/Max-length-of-all-fields-in-the-Dashboard/m-p...