7 Replies Latest reply: May 27, 2011 4:45 AM by Johan Idh

Problem in Round Up of values in bar graph

Hi,

I've very urgent requirement regarding Rounding Up of values in bar graph.

please refer the attached excel sheet.

• Re: Problem in Round Up of values in bar graph

Why do you think that all other graphs than P2 have rounded correctly?

The value looks correct to me since 1,575.6 is a roudned value of 1,575,560,429.9

Are you expecting 429.9 to round up to 430.0?

In that case you need to consider that the underlaying data probabaly contains more decimals so that the real value is for example 429.89999999 meaning the round up is 429.9. Such a microscopic decimal variation can occur when large numbers are calculated since all number are stored as floating point values which are not exact numbers. However, QlikView follows the IEEE Standard on how to store and calculate float values so this is according to specification.

More details on Floating point values can be found at;

http://en.wikipedia.org/wiki/Floating_point

• Re: Problem in Round Up of values in bar graph

Toni, values oare rouding up correctly in case of Stack chart type, but it is not happening in when bar chart type is Group.

i.e. i want

1,575,560,429.9 to be appear as 1,575.6 in both the types.

Sample application is also attached with this, pls check.

• Re: Problem in Round Up of values in bar graph

I wont say this is a very good workaround but offcourse it serve the purpose...Pl see attached.

• Re: Problem in Round Up of values in bar graph

Thank you for concern..

but is you said this is not a good workaround.

i'm still in the same problem.. i need a proper solution for this.

• Re: Problem in Round Up of values in bar graph

I have no quick explanation to this, it is a bit odd behaviour.

Please report it to QlikView support for further evaluation;

support@qlik.com

• Re: Problem in Round Up of values in bar graph

Well the explanation is basically that in Grouped mode the number shown is the value calculated by the chart expression (treated as text not number), whereas for the stacked chart the number is the sum of the values of all the stack segments formatted with the axis setting for number format.

This means that for the Stacked chart the Value shown will be divided by 10e6 as that is the unit of the axis, whereas that will not happen in the grouped one.

This has appeared after we wanted to simplify chart settings by turning "Text on Datapoint"/"Number on Datapoint" into a single setting "Value on Datapoint", using the old "Text" option wherever available.