topic Wrong values, comparison problem in QlikView

Wrong values, comparison problem

Mon, 10 Jan 2011 15:24:56 GMT

Hi,

I´ve got a problem when showing certain values in a chart. Some of the values in the chart are displayed as 0 values.

For example when I am creating a comparison between the values of 2010 and 2009.

I added a screenshot as reference..

The expression I use (for the second one on the right):

SUM({$<Order.Jaar={$(=Only(Order.Jaar)-1)}>} $(vVariable1))

The Variable:



aggr(Sum (Orderdetail.NETSALESAMOUNT)+sum(Ordermisc.NETSALESAMOUNT)
+sum(Orderjob.NETSALESAMOUNT)+sum(Orderoutsourced.NETSALESAMOUNT)
+sum(Orderworkactivity.NETSALESAMOUNT)+sum(Orderitem.NETSALESAMOUNT)+sum(Orderassembly.NETSALESAMOUNT),
 Vertegenwoordiger.Name)

I can't seem to get the right value in this column..

Kind regards,

Re. :Wrong values, comparison problem

martin59 — Mon, 10 Jan 2011 15:44:53 GMT

Hi,

You can try something like that :



aggr( RangeSum ( sum(Orderdetail.NETSALESAMOUNT), sum(Ordermisc.NETSALESAMOUNT), sum(Orderjob.NETSALESAMOUNT), sum(Orderoutsourced.NETSALESAMOUNT), sum(Orderworkactivity.NETSALESAMOUNT), sum(Orderitem.NETSALESAMOUNT), sum(Orderassembly.NETSALESAMOUNT)),
 Vertegenwoordiger.Name)

Wrong values, comparison problem

Mon, 10 Jan 2011 16:04:07 GMT

Hi Martin,

Thank you for your response..

Your solution doesn't seem to work for me, the table shows only "-" if I edit the variable..

Re. :Re: Wrong values, comparison problem

martin59 — Mon, 10 Jan 2011 16:08:25 GMT

Why have you create an aggregate fonction ? If you the average per name you have to do something like this :

avg(aggr(sum(...),Name))

Wrong values, comparison problem

Tue, 11 Jan 2011 11:15:54 GMT

I don't need the average, it has to show the values of the previous year.. (f.e, you select 2010, you will get the 2010 values and the 2009 values)

Any help would be appreciated!

Wrong values, comparison problem

Thu, 13 Jan 2011 10:55:59 GMT

Anyone else with a other solution?

Wrong values, comparison problem

jonathandienst — Thu, 13 Jan 2011 11:47:32 GMT

Have you tried without the aggr?


<blockquote><pre>RangeSum ( sum(Orderdetail.NETSALESAMOUNT), sum(Ordermisc.NETSALESAMOUNT),
 sum(Orderjob.NETSALESAMOUNT), sum(Orderoutsourced.NETSALESAMOUNT),
 sum(Orderworkactivity.NETSALESAMOUNT), sum(Orderitem.NETSALESAMOUNT),
 sum(Orderassembly.NETSALESAMOUNT))

If you do use aggr in an expression in the chart, you need to include all the chart dimensions in the aggr dimension list so the chart can dimension the the expression properly.

Jonathan