Query in SQL Server Management Console returns a value but Qlik returning 0 and null

[GavB]

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.