Value changes after 6 decimal points

[rsdhavle]

We are loading data from one SQL query into qlikview application.

We are grouping it by Product and Client name. Lets say sum(revenue) by product in one table and by client in another.

Both tables are showing different Sum value post 6 decimal points it is same till 6 decimals.

Has anyone experienced this behavior? It is important for us in this case to get same values till 11-12 decimal points. Please guide.

[Anil_Babu_Samineni]

May be assigning to decimals because DB. Can you post sample data how DB and Qlikview looks like?

[vinieme12]

How many decimal places do your numbers actually have?

Qlikview can only retain up to precision of 15 decimal places and may be rounding up the number to store it.

Values and Types