Discussion Board for collaboration on QlikView Scripting.
I am not sure if there is a way but I want to find the length of fields in my QVD file. In the file there are many different fields but I will pick one: Description. Is there a way to determine the maximum length of that field. I know there is a $field command and a data profiler out there. The data profiler seems to calculate the maximum length based on actual data in the field. This could vary from one account to the next. What I mean is this:
Description = This is a test.
Client two = This is the second day of the week.
The length is different. I am looking at the finding the length of the field with no data. If this is not possible that is alright.
Solved! Go to Solution.
if i understood your requirement.
you can try len() function. like below
it will return yoy, Length of string s. The result is an integer
len(Discription) where Discription = 'Test Discription'. it will returns 16.
Try like this
Len(Description) AS DescriptionLength
Now in front end create a text object and use this expression to find maximum length of a field value
Thanks all for your suggestion. I did not explain in clearly. I dont need the max length looking at the actual data in the field. What I was looking for is a way to determine what the max amount of data that can be stored in a given field. Like Description I think the max amount of data is 500 characters but I am not sure. If this is not possible in Qlikview no big deal. Again thanks for your help.
I have never come across a limit to the number of characters that can stored in a text field.
I reckon though that if one stores loads of rows of fields, that contain very long text fields [especially if they are all unique descriptions] then first threshold to cause issues would be performance.
Thanks all for the help. I will need to go back to my development team to get the answer I am looking for. I am not saying there is a limit on the length of the field. What I was saying is I have a field in a QVD File called Description. I want to find the maximum number of characters that field can hold. In other words our development team has set the limit of the various fields in my data set. I was trying to find a work around to determine what those lengths are without going to them. No worries guys.
Have you solved this issue? I'm dealing with the same thing: I'm analyzing a Survey result and some users gave quite a bit long answers. I think a field limit is about 500 characters. Could you find a way to extend that?