OLEDB Read Failed

[Anonymous]

I get an 'OLEDB Read Failed' when i am connecting QlikView to my MS SQL Server data base after adding the following expression at preceding load time:

Sum(MedicalAidAmount + Shortfall)

MedicalAidAmount and Shortfall are two different columns in my data base.  Can one sum across columns at load or this transformation is not allowed.  If i remove this transformation from the preceding load, there is no problem, data reading goes well.

Any ideas on what is going?

[buzzy996]

can u try tis,

Sum(MedicalAidAmount) +sum( Shortfall)

[Anonymous]

Playing a hunch, but can you give the column a unique alias in the result set and see if things get better?

Sum(MedicalAidAmount + Shortfall) AS ReallyUniqueColumnName

[marcus_sommer · Accepted solution]

If you want to use sum() you will need a group by statement, too for this load and if not you should better use:

RangeSum(MedicalAidAmount, Shortfall)

- Marcus

[Anonymous]

Many thanks, that's what i have and it fails load

[Anonymous]

Thanks Marcus will try this

[Anonymous]

Many thanks will try out