Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Date Formatting issue MMM-YY

I am trying to get MMM--YY format for the line chart.

Please see attached file

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Date Formatting issue MMM-YY

Try this as your dimension

=Date(MonthStart(Date_Issued),'MMM-YY')


Capture.PNG

View solution in original post

3 Replies
Highlighted
robin_hausdoerfer
Valued Contributor III

Re: Date Formatting issue MMM-YY

where's the problem?!? it seems to work...

Highlighted
Not applicable

Re: Date Formatting issue MMM-YY

I shouldn't have multiple instances of Jun-16 or Apr-17. It should give me counts grouped on the monthly level

Highlighted

Re: Date Formatting issue MMM-YY

Try this as your dimension

=Date(MonthStart(Date_Issued),'MMM-YY')


Capture.PNG

View solution in original post