Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How can I group dates for a bar chart?

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.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: How can I group dates for a bar chart?

What if you do this:

MonthName(Date#([Closure Due Date],'DD.MM.YYYY'))

2 Replies
MVP
MVP

Re: How can I group dates for a bar chart?

What if you do this:

MonthName(Date#([Closure Due Date],'DD.MM.YYYY'))

martinpohl
Valued Contributor II

Re: How can I group dates for a bar chart?

use monthname instead of month so you will get mar 2016, feb 2016, dec 2015 and so on