Discussion Board for collaboration related to QlikView App Development.
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 🙂