2 Replies Latest reply: May 31, 2010 12:25 PM by EvgenyGin_J RSS

    Ho to calculate average assortment

    EvgenyGin_J

      We have table OrderRows:

      with columns: idDoc(FK), idGoods(FK) and etc

      Please, can u say if it really to calculate avereage assortment as:

      sum(count(distinct idGoods) group by idDoc)/count(distinct idDoc)

      1. how this expression will look like?

      2. we are using operator group by idDoc in sql query, but what the analog of group by in qlikview?

      thanks