2 Replies Latest reply: Sep 13, 2012 3:06 AM by sivaraj seeman RSS

    incorrect aggregation at grand level

    lin ye

      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!