topic Re: Table column value showing 'blank' when the value is too large. in QlikView

Table column value showing 'blank' when the value is too large.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a table with three columns(ID,Name,Address). I am loading a "Select" query to fetch the values form a View in data load.

But for one ID the Address column value is showing as blank even though the value is present in the database.

I suspected that as the value is too large and is not being fetched properly.

I tried changing the content(sub string 400 characters) of ID and value displayed as expected.

is there any way to show the value? even though the value is too large.

Please help me on this issue.

Many thanks!

Raghuveer

Anil_Babu_Samineni — Thu, 01 Feb 2018 16:49:59 GMT

May be share few rows and result set that demonstrates the issue?

zebhashmi — Thu, 01 Feb 2018 16:52:37 GMT

try to fetch with left(Address,10) to see if the length is an issue

Anonymous — Fri, 02 Feb 2018 04:33:43 GMT

Hi Jahanzeb,

Thank you! it worked now.

I used lenghth() instead of hard coding value.

:- left(Address,length(Address))

shiveshsingh — Fri, 02 Feb 2018 05:43:10 GMT

Can you share the value which is not showing?

Anonymous — Fri, 02 Feb 2018 06:18:10 GMT

Hi Shivesh,

My column value is more than 523 characters.