topic Re: Concat() Limitation in QlikView

Concat() Limitation

tresB — Tue, 05 Aug 2014 13:09:30 GMT

I had been working on the post : Re: search for values of a field on activate sheet which lead me to do some R&D and I found that concat() could not generate result beyond the length 2^16 -1 = 65535. Is this a known limitation?

Re: Concat() Limitation

DavidFoster1 — Tue, 05 Aug 2014 14:25:46 GMT

I think you have hit the byte limit of a text value on the front-end.

Have you considered creating a child table with a record per word and searching that instead?

Re: Concat() Limitation

tresB — Tue, 05 Aug 2014 17:34:28 GMT

Thanks David for replying.

Might be you are right. But I am not very sure about the technicality of qlikview when it comes to front-end calculation. Alternatives could be explored. But I am more interested on it's explanation here. It could have been better if the technicality could be explained by authority. May be someone from qlik like Henric Cronström could shed some light.

Update: Just found another thread discussing same issue: Re: Limitation in Text Object of 65,535 Chrs!?

Re: Concat() Limitation

tresB — Wed, 06 Aug 2014 11:37:09 GMT

I would like to bring this on top of the stack once again.

Re: Concat() Limitation

DavidFoster1 — Wed, 06 Aug 2014 12:00:44 GMT

In that case I think you would get a faster response by raising a support call directly with Qlik.

Re: Concat() Limitation

tresB — Wed, 06 Aug 2014 12:04:08 GMT

That's true.