topic Chart Label changes in QlikView

Chart Label changes

tellmalaika17 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a requirement to make changes in the chart axis label to show 6 months apart. For eg : Dimension Axis to show months like Jan, July instead of Jan, Feb, March and so on. This can be achieved with continuous option in Axes however my chart changes when the continuous option is checked. See below pic. Expected result should be Jan-12, Jul-12, Jan-13, Jul-13 and so on.

Re: Chart Label changes

sunny_talwar — Tue, 30 Aug 2016 18:41:25 GMT

Would you be able to share a sample to look at?

Re: Chart Label changes

sunny_talwar — Tue, 30 Aug 2016 18:50:26 GMT

Or something like this?

Settings: Axes tab

Number tab

Re: Chart Label changes

ramasaisaksoft — Wed, 31 Aug 2016 05:45:34 GMT

Hi Malaika,

=if(Month([Project Actual Start Date])='Jul' or Month([Project Actual Start Date])='Apr',MonthName([Project Actual Start Date]))

Note:- I have only 2016 data so i got only those values.

it will give month year name like below.so write this in your dimension.