topic Re: Field Length Question in QlikView

Field Length Question

Mon, 21 Jul 2014 03:15:09 GMT

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

Re: Field Length Question

israrkhan — Mon, 21 Jul 2014 03:30:04 GMT

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

Re: Field Length Question

jagan — Mon, 21 Jul 2014 04:04:03 GMT

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.

Re: Field Length Question

jonathandienst — Mon, 21 Jul 2014 05:50:12 GMT

Simply put this expression in a list box:

=Max(Len(Description))

HTH

Jonathan

Re: Field Length Question

Mon, 21 Jul 2014 16:59:41 GMT

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

Re: Field Length Question

Anonymous — Mon, 21 Jul 2014 17:12:18 GMT

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.

Re: Field Length Question

Anonymous — Mon, 21 Jul 2014 17:15:14 GMT

Agreed, I think you will encounter performance issues before you ever hit the QV limits due to todays current hardware limitations.

Re: Field Length Question

Mon, 21 Jul 2014 17:26:05 GMT

I believe, there is no length constraints for string field values in Qlikview.

Re: Field Length Question

Mon, 21 Jul 2014 18:47:42 GMT

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.

Re: Field Length Question

arieidel — Fri, 29 May 2015 15:24:15 GMT

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