topic Re: Rounding issue Chart vs Graph in QlikView

Rounding issue Chart vs Graph

Tue, 07 Aug 2012 12:17:38 GMT

I am currently running in to an issue regarding number validation between a pivot table and a graph. They are both using the same exact expression and dimension, i have made sure of it. I even checked the number tab in the chart and graph properties. However, the pivot table is giving me different rounding numbers than the bar graph. For instance doing the math on a calculator i am getting a number such as 31.958. This number will be 32.0 in the pivot table, yet in the graph this number comes up as 31.9. I have tried the rounding expression and this seems to not really do anything. Is there a reason that the Bar graph rounds differently than the pivot table?

Re: Rounding issue Chart vs Graph

giakoum — Tue, 07 Aug 2012 12:23:17 GMT

This would be rather disappointing, if it really happens. Did you check that you also use exactly the same format pattern for the number? A sample application would help.

Re: Rounding issue Chart vs Graph

Tue, 07 Aug 2012 12:25:44 GMT

Yes i did. I have the number set to decimal fixed to 1 decimal place and the number looking like #,##0.0

Re: Rounding issue Chart vs Graph

Anonymous — Tue, 07 Aug 2012 12:52:21 GMT

make the num fomat to #,##0 . hope this might give you the crrt solution

Re: Rounding issue Chart vs Graph

Tue, 07 Aug 2012 13:42:28 GMT

Although this does make the charts correct. We wanted the number to be more accurate and not round to the nearest interger, but rather to the nearest tenth.

Re: Rounding issue Chart vs Graph

Tue, 07 Aug 2012 13:44:51 GMT

Rather than using the number formatting try adding Num() to your expression and format here then use the expression default (note in QV11 SR1 you may have to rebuild the chart for expression default to work)

Re: Rounding issue Chart vs Graph

Tue, 07 Aug 2012 14:07:01 GMT

Although this did help solve one object, and linked the chart and graph correctly. It is not helping with all of them. So i am still trying.

Re: Rounding issue Chart vs Graph

Tue, 07 Aug 2012 14:12:27 GMT

Rule of thumb, formatted expression values are generally more reliable than a visual editor

Re: Rounding issue Chart vs Graph

swuehl — Wed, 08 Aug 2012 09:42:14 GMT

Can you post a small sample file that demonstrate your issue?

Is it maybe related to this issue?

http://community.qlik.com/message/237958#237958

Re: Rounding issue Chart vs Graph

Wed, 08 Aug 2012 11:44:35 GMT

Ths issue has been resolved. Thank you everyone for your help. Had to do with the usage of a Sum(Aggr( function in what we were dividing by.