Not sure why nvarchar value in coming null after qliksense app reload .

[suvechha_b]

Hi All ,

My SQL Server Table "POLICY" has one "LINE_OF_BUSINESS" field .

Having value like below - 

Not sure why after the reload in qliksense app the value is coming null or blank with data in LINE_OF_BUSINESS field.

Please kindly assist , why the value is coming null , I am just running the sql select query in qliksense app script.

Thanks,

Suvechha 

[Anil_Babu_Samineni]

How is the query looks like?

[suvechha_b]

LOAD

      "POLICY_ITEM_KEY",

      "POLICY_ITEM_DESCRIPTION",

       TEXT(LINE_OF_BUSINESS) AS "LINE_OF_BUSINESS";

SQL SELECT

      "POLICY_ITEM_KEY", 

      "POLICY_ITEM_DESCRIPTION",

      "LINE_OF_BUSINESS"

  FROM [Tablename];

[Anil_Babu_Samineni]

Are you getting any data using this?

SQL SELECT

      "POLICY_ITEM_KEY", 

      "POLICY_ITEM_DESCRIPTION",

      "LINE_OF_BUSINESS"

  FROM [Tablename];

[suvechha_b]

I am getting values in SQL SERVER query like below - 

But , when loading this sql query to qliksense ,

I am getting NULL in LINE_OF_BUSINESS field value.

[suvechha_b]

 SQL Server Result

Qliksense Result 

Wandering why the qliksense is not getting the values in .?

[suvechha_b · Accepted solution]

I problem got resolved when the Database table "tablename" change the field description from  nvarchar(max) to nvarchar(10) .

The table was containing 10 character values in it and decribing it to nvarchar(max) which was causing problem in my Qliksense App.