Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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]