4 Replies Latest reply: Feb 20, 2013 1:21 PM by Raj Vadde RSS

    Why my Aggregation values are so high  for simple expression like sum(sales)

    Raj Vadde

      Hi all,

              This might be dumb question .......but i'm struggling to find a answer

       

      In my script i'm doing a group by (for a range of dates using a for loop for every week) with respect to my primary key and i see all aggregated values for a given key

       

      but when i select a single key(primary key values my and gave expression like sum(sales ) ina text box..the values are very high ..

       

      can somebody throw some light on how group by and aggregation work in qlikview.

       

      and here i'm attaching my application and data file to get an overview of what i'm doing ...

       

      i'm not sure whether it's right way to use a for loop and follwed by groupby ..plz throw some light on this

       

      and guide me with your valuable suggestion

       

      H