Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlikuser09
Creator II
Creator II

calculate daily average in a year bar chart

I'm using this formula to get the count of the sales dates

Count({< DateType = {'Sales Date'}>} [Account Number]), how can i add the average here to get the average daily sales count by year and month .

Labels (1)
1 Reply
Vegar
MVP
MVP

Create a chart or table where you have Year (and Month) as dimensions. 

To calculate the average sales amount you need to calculate your sales amount, let's assume that it is Sum([Sales Amount]), and divide it by the number of days associated to your dimension values, Count({< DateType = {'Sales Date'}>} [Account Number]). 

Your expression  will look something  like this.

Sum([Sales Amount]) / Count({< DateType = {'Sales Date'}>} [Account Number])