Discussion Board for collaboration related to QlikView App Development.
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.
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]
what does your source data looks like ? can you provide some sample data?
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
Thank You Dave. It helped me and completed the task.
I am not able open the .qvw files. Could you please paste the formula here. I need this calculation. Please assist.