Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i want to calculate the average of actual sales of products. The problem that the number of period changes from a product to another beacause it depends on its launch period. To explain more we take for example a product A, it is a new product and it was launched two months ago and a product B that has more values because it is older than the product A.
So i have products and their sales per month and i want to calculate the sales average.
Thank you,
Alâa Eddine.
as YearMonth is a dimension, this could cause the problem ...
you may try to use count in conjunction with TOTAL <SalesAggr...> (refer to the doc for more details)
Hello,
which document please ?
Can you send it to me ?
I mean Qlikview Documentation