topic Re: Field Values with blanks in a straight table in QlikView

Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 05:47:04 GMT

I have done a straight table report using MSSQL Server as a data source. Part of the data source from MSSQL Server looks as follows:

Part of the straight table report looks as follows:

The SponsorApplicant field in the data source has been renamed Applicant in the above straight table. The straight table has some blanks in the Applicant field as can be seen from the table above. I queried the source table for for NULL or blank SponsorApplicant field values with no results. Also a physical inspection of the table shows that this field has not blank or NULL field values.

The following script pulls the data into QV:

What could be causing the presence of blanks in the Applicant field??

Regards.

Re: Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 05:53:34 GMT

may be mapping or Data Model of same table with other model tables is causing the same?

sample data or app?

Re: Field Values with blanks in a straight table

HirisH_V7 — Fri, 29 Jan 2016 06:05:48 GMT

Hi,

Just load this single table and check the output, this may be due to this SponsorApplicant field and AppNo are mapped with some other table or so,

Check this way,

HTH,

Hirish

Re: Field Values with blanks in a straight table

ramasaisaksoft — Fri, 29 Jan 2016 06:13:35 GMT

Hi Christoper,

Will you please check your data model(Ctrl+T) of this column table is having data or not in preview ?

if you have data there then UI is showing NULL data because of Selections/Filters else you did wrong while you creating the data model/Script.

if possible post dummy data we will help to u

Re: Field Values with blanks in a straight table

jagan — Fri, 29 Jan 2016 06:42:54 GMT

Hi,

I think other tables also, there may be chances for this if there is no values in Table1 but in Table2 then this may occur.

Regards,

jagan.

Re: Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 07:35:59 GMT

Thank you Bairaj for your input

Re: Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 07:36:44 GMT

Thanks Hirish will check

Re: Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 07:37:24 GMT

Thanks Rama

Re: Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 07:38:07 GMT

Ok will check further

Re: Field Values with blanks in a straight table

Anonymous — Fri, 29 Jan 2016 07:39:48 GMT

Dear All

I reloaded the files based on your inputs. I should have pulled an old 'application' which was not up to date and used with newer tables. On reloading using the correct tables, every thing works fine.