topic Re: Manupulate axis. Show month-year only in QlikView

Manupulate axis. Show month-year only

Fri, 24 Apr 2015 12:35:32 GMT

Hi,

Need to show all data points (sum per date),

however I only wanna see month-Year on the dimension axis, for instance "Jan-2015".

As you can see, showing all dates does not work that well.

Any ideas?

Re: Manupulate axis. Show month-year only

sunny_talwar — Fri, 24 Apr 2015 12:39:39 GMT

What happens when you change your dimension from Date to MonthName(Date) and on the axis tab keep the axis continuous?

Best,

Sunny

Re: Manupulate axis. Show month-year only

Fri, 24 Apr 2015 12:46:31 GMT

This happens, only one sum per month (also numbers instead of the actual month name).

//O

Re: Manupulate axis. Show month-year only

sunny_talwar — Fri, 24 Apr 2015 12:48:27 GMT

Can you share a sample

Best,

Sunny

Re: Manupulate axis. Show month-year only

buzzy996 — Fri, 24 Apr 2015 12:48:49 GMT

try this way,

Need to show all data points (sum per date), ---activate scroll bar from prenstaction tab---Chart scrolling--Enable X-Axis scroll bar.

however I only wanna see month-Year on the dimension axis, for instance "Jan-2015". ---use calculated dimension as Month(Datefield))&'-'&Year(Datefield)

Re: Manupulate axis. Show month-year only

ankitaag — Fri, 24 Apr 2015 12:52:00 GMT

Write the calculated dimension as =Month(Date)&'-'&Year(Date)

Re: Manupulate axis. Show month-year only

Fri, 24 Apr 2015 14:05:49 GMT

Pls see attached

//O

Re: Manupulate axis. Show month-year only

Anonymous — Fri, 24 Apr 2015 14:14:23 GMT

The closest I can think of is to keep Date as dimension but to use continuous x-axes. Still there is a problem - Months may be skipped or duplicated depends on the chart size.

Re: Manupulate axis. Show month-year only

stigchel — Fri, 24 Apr 2015 14:33:27 GMT

You can also disable the dimension Show Label and add an extra expression with Text on Axis enabled, something like

=if(Date=MonthStart(Date),Month(Date))&'-'&Year(Date))