topic Re: Average Monthly sales in QlikView

Average Monthly sales

Anonymous — Tue, 14 Nov 2017 08:15:40 GMT

Hi All, I have working days table for two years defined with number of working days for each month. In facts table each day sales amount is available. How to get average monthly sales? i.e total sales of a month divide with number of working days.

PFA. Thanks to advice.

Regards,

Krishna

Re: Average Monthly sales

tresB — Tue, 14 Nov 2017 08:36:58 GMT

Create a Month field in the script, like:

Month(Date) as Month

and then use this Month field as dimension in the chart and use expression like:

= Sum(Sales)/[Number of working days]

Re: Average Monthly sales

woshua5550 — Tue, 14 Nov 2017 08:41:11 GMT

what does your source data looks like ? can you provide some sample data?

Re: Average Monthly sales

Anonymous — Tue, 14 Nov 2017 10:44:54 GMT

Hi Dev,

i have working days table as attached.

in Qlikview i want respective working days as below.

Month 2016WDays 2017Wdays

Jan nofodays nofodays

Feb nofodays nofodays

Mar nofodays nofodays

Re: Average Monthly sales

woshua5550 — Tue, 14 Nov 2017 10:52:46 GMT

check this

Re: Average Monthly sales

Anonymous — Wed, 15 Nov 2017 06:52:25 GMT

Thank You Dave. It helped me and completed the task.

Re: Average Monthly sales

Shweta_Pattar — Wed, 15 May 2019 09:48:01 GMT

Hi Dave,

I am not able open the .qvw files. Could you please paste the formula here. I need this calculation. Please assist.