Discussion board where members can get started with QlikView.
I would like to Cost by Sale ratio for every main account, my scenario is something like this;
how to right below expressions in a straight table?
Sorry to compute Cost by Sale ratio
=Avg(TOTAL Aggr(Sum(cost)/Sum(sales), year, month))
=Column(1) - Column(2)
The second expression might change if you need a total average by main account
=Avg(TOTAL <[main account]> Aggr(Sum(cost)/Sum(sales), year, month))