Hi,
I have strange issue a query I am running against a view in SQL Server returns a number for one field and a string for another. For one example the fields come through correctly in Qlik in the other the number comes through as 0.00 and the text field as null. Any help would be great.
Thanks,
Gavin
The query is as follows:
Select ID, COST, CODE
FROM V3
WHERE YEAR = '2022'
AND WEEK = '45'
AND ID IN ('MS01834', 'TP01428');
Below is what is returned when running the query from SSMS but when reloaded in Qlik the costs for TP01428 returns as 0.00 and the Codes as NULL for all records.
TP01428 0.000000 NULL
TP01428 1.120000 SC00002
MS01834 0.000000 NULL
MS01834 1.680000 SC00001
TP01428 0.000000 NULL
TP01428 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
TP01428 0.000000 NULL
MS01834 0.000000 NULL
TP01428 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
MS01834 0.000000 NULL
TP01428 0.000000 NULL
MS01834 0.000000 NULL
TP01428 0.000000 NULL
MS01834 0.000000 NULL
TP01428 0.000000 NULL
TP01428 0.000000 NULL
TP01428 0.000000 NULL
TP01428 0.000000 NULL
TP01428 0.000000 NULL
MS01834 0.000000 NULL
We are using QLIK SENSE ENTERPRISE June 2019 using an OLE DB connection to SQL SERVER 11.