Discussion Board for collaboration related to Creating Analytics for QlikView.
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:
Try the function Len() and Max().
This app can give you an idea.
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