incorrect aggregation at grand level

yelin_nyu — Wed, 12 Sep 2012 22:49:05 GMT

Hi I am a Qlikview newbie. I want to draw a line graph using the table in test123 file: I want to add the positive inventory together, so change all negative values to 0 in adjusted inventory field.

If I add Account to the dimension in Graph table, then Adjusted Inventory Value would be correct, but if I take it out, then the calculation changes to inventory. I want to see sum of adjusted inventory by date.

Order_date Adjusted Inventory Value

total $196

1/1/12 $76

1/10/12 $120

How do i fix it? Thanks!

Re: incorrect aggregation at grand level

swuehl — Thu, 13 Sep 2012 07:06:13 GMT

Try

=sum(if(Inventory*Price<0, 0, Inventory))*avg(Price)

Hope this helps,

Stefan

Re: incorrect aggregation at grand level

sivarajs — Thu, 13 Sep 2012 07:06:23 GMT

PFA

Guess that's your expected result

--Siva

topic Re: incorrect aggregation at grand level in QlikView

incorrect aggregation at grand level

Re: incorrect aggregation at grand level

Re: incorrect aggregation at grand level