Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Client one:
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.
Thanks
David
Hi
Simply put this expression in a list box:
=Max(Len(Description))
HTH
Jonathan
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.
Kind Regards
Khan
Hi David,
Try like this
LOAD
*,
Len(Description) AS DescriptionLength
FROM DataSource;
Now in front end create a text object and use this expression to find maximum length of a field value
=Max(DescriptionLength)
Regards,
jagan.
Hi
Simply put this expression in a list box:
=Max(Len(Description))
HTH
Jonathan
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.
David
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.
Agreed, I think you will encounter performance issues before you ever hit the QV limits due to todays current hardware limitations.
I believe, there is no length constraints for string field values in Qlikview.
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.
Hello David,
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?
Thanks,
Ariel