Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Average Monthly sales

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

6 Replies
Highlighted
MVP
MVP

Re: Average Monthly sales

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]

Highlighted
Creator III
Creator III

Re: Average Monthly sales

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

Highlighted
Contributor III
Contributor III

Re: Average Monthly sales

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

Highlighted
Creator III
Creator III

Re: Average Monthly sales

check this

@

Highlighted
Contributor III
Contributor III

Re: Average Monthly sales

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

Highlighted
Contributor
Contributor

Re: Average Monthly sales

Hi Dave,

 

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