topic Re: Re: Error sum value bar chart in QlikView

Error sum value bar chart

realpixel — Fri, 14 Feb 2014 16:30:49 GMT

Hello,

I have a bar chart with an expession sum(MFAC) who give the total but this total is false.

If I change bar chart to straight table with same expression an same dimenssion, the total is correct.

Someone have an idea why in bar chart the total is different from straignt table? It seem that the negative value (- 366 600) is not calculate is bar chart.

Re: Error sum value bar chart

MK_QSL — Fri, 14 Feb 2014 16:43:04 GMT

Can you please load your sample file?

Re: Error sum value bar chart

giakoum — Fri, 14 Feb 2014 16:53:08 GMT

if your axes start at 0 and up, maybe it is not calculated...

Re: Re: Error sum value bar chart

realpixel — Fri, 14 Feb 2014 17:36:31 GMT

Hello,

Find attached a sample, if I use a csubtype grouped, I see all values, negative too, but when I use the subtype grouped only the positve value are available, no negative value.

I need to have a bar chart grouped with total = posite value - negative value.

Re: Error sum value bar chart

MK_QSL — Fri, 14 Feb 2014 17:41:34 GMT

Please check enclosed file.

The negative value is indeed coming but due to the big difference between negative and positive value, it's not clearly visible.

I have remove the stacked option and you can see the value is coming.

Hope this help

Re: Re: Error sum value bar chart

realpixel — Fri, 14 Feb 2014 18:01:54 GMT

Thank you Manish,

The problem is the total of expression when the chart is stacked is false.

The total is 675 747 684 when is stacked or it's must be 675 381 084 (-366 600 + 672 742 164 + 3 005 520 = 675 381 084) why?

Re: Error sum value bar chart

MK_QSL — Fri, 14 Feb 2014 19:09:37 GMT

This is a two dimension and one expression chart.

How can you expect a total as the one which you have mentioned above.

There are two ways to get the desired total in Bar Chart

1) Remove the 2nd expression ETAT FACTURE and you can now see that your chart is showing the total you want..

2) Go to Expression tab and untick Values on Data Point for the SUM(MFAC) expression.

Now Add one more Expression SUM(Total MFAC) and Untick Bar and Tick Values on DataPoint...

Hope this will help you.

Re: Error sum value bar chart

maxgro — Fri, 14 Feb 2014 21:21:29 GMT

IMHO the total is correct

or would you prefer 0 as total?