3 Replies Latest reply: Aug 21, 2016 10:37 PM by Clement Bitton RSS

    Aggregation problem in set analysis

    Clement Bitton

      Hi all,

       

      I got a problem in a set analysis.

       

      I run the following :

      avg({$<date={"$(=min(date))"}>} value) 

       

      Which should give me the average of the value on the minimum date.

       

      However the dollar sign function $(=min(date)) return the minimum date of the whole selected data set.

       

      So if I produce the following table :

      qlik example.png

       

      You can see that most of time Max average and Min average are null, simply because on the $(=min(date)) is using the minimum and the maximum of the whole selected data.


      I have been trying couple of options (use column(), some aggregation ...)

       

      Do you have an idea so the max average and min average will return the average on the Max date and min date for that code ?

       

       

      Thanks you !