Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
dplr-rn
Partner - Master III
Partner - Master III

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
dplr-rn
Partner - Master III
Partner - Master III

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/

anonymous1
Contributor III
Contributor III
Author

thanks this worked 🙂