Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
anonymous1
Contributor III
Contributor III

Qlikview avg/aggr

hi guys, im very new qlikview so hoping someone can point me in the right direction.

im trying to create a line chart which will show me with the average quantities for each month, for each site:

Avg(Aggr(Sum(QTY), DATE, SITE))

my issue is that the DATE is in the format DD-MON-YYYY, and i need this chart to show each month, and not every date. 

I've tried:

Avg(Aggr(Sum(QTY), DATE(DATE#(DATE,'DD-MMM-YYYY'), 'MMMM'), SITE)

but it doesnt work.

Anyone any ideas how this could be grouped by each month, rather than each date?

TIA

Labels (2)
1 Solution

Accepted Solutions
dilipranjith
Partner
Partner

In your load script create a Month column. and use that in the aggr instead of DATE

better still create a master calendar which will have month, month year etc.

 

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

View solution in original post

2 Replies
dilipranjith
Partner
Partner

In your load script create a Month column. and use that in the aggr instead of DATE

better still create a master calendar which will have month, month year etc.

 

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

View solution in original post

anonymous1
Contributor III
Contributor III
Author

thanks this worked 🙂