Ho to calculate average assortment

[#1]

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

[martin59]

Hi,

You can try this in a text object to test, before to use the expression in others QV objects :

avg(aggr(Count(Distinct idGoods), idDoc))

[#3]

thank you very much!