2 Replies Latest reply: May 27, 2014 9:15 AM by Dariusz Mielczarek RSS

    Using a calculated dimension in Aggr()

      Hello fellow qlikviewers,

       

      I was wondering about wether it was possible to use a calculated dimension to aggregate by using the Aggr() function.

      I have a dataset where data is logged every second, which I would like to, for example, aggregate per 15 minutes.

       

      I can make a straight table chart using

           Floor(Sec,900)

      as a dimension. This would however not enable me to take the average of each result.

       

      I tried using the following (example):

           Avg(Aggr(Count(Something),Floor(Sec,900)))

      But it seems the Aggr() function won't accept this (getting no results).

      I've also attached a quick example

       

      What I can do is create a new field during the load script the create the value which I wish to aggregate by (Floor(900) in above examples), but I would prefer not to have to do this.

       

      Any help will be greatly appreciated!

       

      Kind regards,

      Daniel