Discussion board where members can get started with Qlik Sense.
How can I group dates (current format DD.MM.YYY) for a bar chart by month and year? I tried: Month(Date#([Closure Due Date],'DD.MM.YYYY')), but this puts all month across years together.
Go to Solution.
What if you do this:
MonthName(Date#([Closure Due Date],'DD.MM.YYYY'))
use monthname instead of month so you will get mar 2016, feb 2016, dec 2015 and so on