Discussion board where members can get started with QlikView.
I'm creating a chart which displays the monthly average sales per product however I have a daily data set in Excel.
In the Expressions tab, I used this expression: =Avg(Aggr(Sum(Sales),Date,Product)) and upon applying, chart looked like this
The scale was a lot smaller since I have data set in daily format but what I need is the monthly averages.
I've also tried editing the Script using the MonthStart string to no avail. Hope someone can help me on this.
Have you tried this?
Where MonthYear is calculated in the script like this
Date(MonthStart(Date), 'MMM-YYYY') as MonthYear
View solution in original post
I did it! Thanks for the help!