This content has been marked as final. Show 2 replies
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?