Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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 🙂