Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
How is the query looks like?
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];
Are you getting any data using this?
SQL SELECT
"POLICY_ITEM_KEY",
"POLICY_ITEM_DESCRIPTION",
"LINE_OF_BUSINESS"
FROM [Tablename];
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.
SQL Server Result
Qliksense Result
Wandering why the qliksense is not getting the values in .?
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.