Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
johanfo2
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
Not applicable

hi,

Try the function Len() and Max().

Rebeca

prodanov
Partner
Partner

Hi,

     This app can give you an idea.

Regards

raajaswin
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