Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
josecanalla
Creator
Creator

Line chart not shows Month Year name

Hello, I use Master Calendar and I create al line chart with dimension "MonthYear" and a measure. In the X-axis I get: http://prntscr.com/i7m7j0 and I want to get oct-2017, nov-2017, etc...

Why not works?

Thanks!

Edit: reuploaded image

imagen.png

1 Solution

Accepted Solutions
OmarBenSalem

under aspect> x-axis: uncheck the "continue" option:

Capture.PNG

View solution in original post

6 Replies
josecanalla
Creator
Creator
Author

I found a workaround. Converting the chart to bar chart shows the month names correctly... but if I want a line chart is there a way to do this?

sunny_talwar

I am unable to see the image from the url that you have posted, can you repost the image here?

Uploading a Sample

josecanalla
Creator
Creator
Author

I reuploaded the image in my original post

sunny_talwar

May be try this as your dimension?

Date(MonthStart(YourDimension), 'MMM-YYYY')

OmarBenSalem

under aspect> x-axis: uncheck the "continue" option:

Capture.PNG

SmritiAdekar
Contributor
Contributor

I am facing the same issue with trendlines.

Date(MonthStart(YourDimension), 'MMM-YYYY') this doesnt help change x axis labels for line chart. It just changes the formatting of date for popover when you hover over a data point.

If i convert the same graph with same formulas to bar chart that does it but i am not getting Jul-18 as a monthyear format with  Date(Num#([MonthYear]),'MMM-YY')  in trendlines [ Num# because i have a crosstable]