Qlik Community

Qlik Sense App Development

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

paulyeo11
Valued Contributor II

How to compute average sales per day ?

Hi All

Can some one share with me how to compute the average sales per day ?

For example sales for the month of May 2015 is $30

Average sales per day it is = $30/30 = 1

it is correct ?

Paul

1 Solution

Accepted Solutions
MVP
MVP

Re: How to compute average sales per day ?

It could be (with dimension of Month)

     Sum(Sales) / Day(MonthEnd(Month))

Adjust the field names to the correct names for your model.

4 Replies
MVP
MVP

Re: How to compute average sales per day ?

It could be (with dimension of Month)

     Sum(Sales) / Day(MonthEnd(Month))

Adjust the field names to the correct names for your model.

MVP
MVP

Re: How to compute average sales per day ?

If Month is not a date, convert to a date using MakeDate, and use that in the MonthEnd statement.

santhoo_san
Contributor II

Re: How to compute average sales per day ?

Average sales per day =

( Total Sales for a period

/

No of days of that period (No of working days in some cases))

in your example as a general case = it is $30 / 31 (May has 31 days) = 0.968.

paulyeo11
Valued Contributor II

Re: How to compute average sales per day ?

Hi Sir

Thank you.

Paul