Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Issue with SAP connector

Hi All,  I am extracting data from SAP BW to Qlikview and getting some difference   The resulting table has for some (but not all!) records different values than the table in BW.  Here is one example (same record from BW data browser and Qlikview)                   BW (point as thousand separator, 4851 is the correct value from business point of view): 4.851                 Qlikview (point as decimal separator so the number is one hundredth of what it should be):48.51  Any idea why this happens and how to fix it?  Thanks

4 Replies
dcj
Valued Contributor II

Re: Issue with SAP connector

I recommend this track to find your problem:

- Certify that you are using the last version of Qlikview Server and SAP Transports;

- If you have the last version, try to extract data from another table and analyze if it´s happen again.

This could be a bug.

danielrozental
Honored Contributor II

Re: Issue with SAP connector

I think you should make sure the decimal and thousands separator matches your database

SET ThousandSep='.';

SET DecimalSep=',';

Not applicable

Re: Issue with SAP connector

Hi,   Sorry for late response, yes I am using 5.6 old version..  Thank You!

Not applicable

Re: Issue with SAP connector

Hi Daniel,  Thanks for your input but this change could not help.