Value on data point in stacked bar chart expression depending on chart layout

[swuehl]

The values on data point in a stacked bar chart seem to be depending on the chart layout, i.e. resizing the chart will change the displayed value.

Discussed in this thread (with sample file attached):

http://community.qlik.com/thread/53261

Confirmed in QV 11.00.11282.0 SR1 - 32 bit and 64 bit version.

Not confirmed in QV 11.00.11154.0 IR - 32bit.

[rwunderlich]

I tested on QV10 SR4 - 9282 - 64bit. Problem does not occur on that level. Value is correct no matter the size of the chart.

-Rob

[s_uhlig]

dead link - do you still have the sample?

Regard

Sven

[swuehl]

Too bad that it is so easy to delete complete threads in this forum...

The original thread was called "Significant rounding errors in QV", the OP's name is ingoniclas.

But I think I've found the sample application.

Rob posted this work-around:

"I can reproduce the problem. I am also using 11.00.11282.0 SR1 - x64. Stfan, are you 32 or 64bit?

Note that the same chart fast changed to a pivot table gives the correct result, so the data model is correct. Also note that if you change the sort order for the second dim (Kassenbezeichnung) from A>Z to Z>A, the correct result will appear for Baden-Württemberg. The Bayern value will also change, but still not correct.

If you do the math, you can see it's the last couple of Insurance values that are missing.

The problem appears to caused by QV deciding what bars can be displayed on the chart given the display size. If you narrow or widen the chart, the value will change.

The workaround is to add another expression

=Sum(TOTAL<KV>Fälle)

uncheck Bar and check Values on Data Points.

"

[swuehl]

Just stumbled upon this old thread.

Seems not to be present in QV11.20 SR11 anymory.