Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Customise axis label text in charts/graphs

Hi all,

I have a chart where months form the x-axis, and a percent of change from the previous month is being measured along the y-axis. At the moment, the x-axis values only show one month in the label (e.g Feb-17), but I'd like to customise it so it shows, for example, Jan-Feb-17. Obviously, is like this repeated for every month on there with the month before it.

Is this something thing that is possible?

Thanks

1 Reply
adamdavi3s
Master
Master

The simplest way is probably to load up this field as a dimension and use it?

So for example in your standard master calendar loader you can use something like

Month( addMonths(TempDate,-1))&'-'& Month(TempDate)&Year(TempDate) as MonthShift,

Please see the attached