Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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/
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/
thanks this worked 🙂