topic Re: Limitation in Text Object of 65,535 Chrs!? in QlikView

Limitation in Text Object of 65,535 Chrs!?

Jason_Michaelides — Fri, 14 Feb 2014 15:38:05 GMT

Hi all,

I have just encountered something I have not seen before. See attached demo doc - it seems if you try and put more than 65,535 chrs into a text box it just shows blank.

Has anyone else encountered this?

Obviously, the need to do this is somewhat limited, but it's interesting...and I'd like to know if there's any way to turn off the limit - anyone have any ideas?

Thanks,

Jason

Re: Limitation in Text Object of 65,535 Chrs!?

rbecher — Fri, 14 Feb 2014 16:54:25 GMT

Of course there must be a limit. Maybe you can display the text line-wise or in paragraphs within a table chart.

Re: Limitation in Text Object of 65,535 Chrs!?

Jason_Michaelides — Fri, 14 Feb 2014 16:59:10 GMT

I don't really need to display it. I was testing something to pass a string out to another system and noticed the limitation. I agree there obviously has to be a limit although I think 65k chrs is maybe a little low given the size of some applications. No coincidence that it matches the exact Excel row limit that chart objects are still limited to for exporting either, I'd guess...

Re: Limitation in Text Object of 65,535 Chrs!?

rbecher — Fri, 14 Feb 2014 17:03:58 GMT

Yea, maybe some old 16bit stuff. However you could always use a left()..

Re: Limitation in Text Object of 65,535 Chrs!?

rbecher — Sun, 16 Feb 2014 14:56:17 GMT

I have to remember this. One should use Concat on high amount of values with a left always:

=Left(Concat(DISTINCT Number,','), 65535)

..because it's also limited in a straight table chart.

Re: Limitation in Text Object of 65,535 Chrs!?

Jason_Michaelides — Mon, 17 Feb 2014 09:36:28 GMT

Me too - thanks Ralf.