QlikView App Dev

[anonymous1]

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

[dplr-rn · Accepted solution]

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]

thanks this worked 🙂