Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Rehan
New Contributor III

Quarterley Average

I have a monthly data for sales Sum(Sales). Now I have created a quarter field and for each quarter I would like to get avg sales /Month. For Example if Jan =50, Feb =50 and Mar = 30, I want the Q1 sales to be 130/3 or If I have only Jan and Feb I want the Q1 sales to be 100/2.

How I can accomplish that ?

2 Replies
Partner
Partner

Re: Quarterley Average

Hi,

 

you could try with this expression:

 

Sum(total <quarter> sales)
/
count(total <quarter> month)

sugathirajkumar
New Contributor III

Re: Quarterley Average

sum(aggr(sum(Sales),Quarter))/sum(aggr(count(Month),Quarter))