topic Re: Max length of all fields in QlikView

Max length of all fields

johanfo2 — Wed, 19 Jun 2013 13:11:30 GMT

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

Re: Max length of all fields

Wed, 19 Jun 2013 13:20:51 GMT

hi,

Try the function Len() and Max().

Rebeca

Re: Max length of all fields

prodanov — Wed, 19 Jun 2013 14:01:07 GMT

Hi,

This app can give you an idea.

Regards

Re: Max length of all fields

raajaswin — Tue, 23 Jun 2020 13:42:24 GMT

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

Re: Max length of all fields

raajaswin — Wed, 24 Jun 2020 06:54:02 GMT

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