Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calculating average of values of n periods

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.

12 Replies
olivierrobin
Specialist III
Specialist III

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)

Anonymous
Not applicable
Author

Hello,

which document please ?

Can you send it to me ?

olivierrobin
Specialist III
Specialist III

I mean Qlikview Documentation