topic Re: Chart: x-Axis with clustered/dynamical legend in QlikView

Chart: x-Axis with clustered/dynamical legend

Anonymous — Fri, 14 Mar 2014 10:01:46 GMT

Hi,

in a chart there to many values on x-axis. First value of chart is GJ_Woche 2010/01. How can I display the x-axis like attached pic?

2010/01, 2011/01, 2012/01,... Can this legend also define dynamical?

Regards

Stefan

Re: Chart: x-Axis with clustered/dynamical legend

hic — Fri, 14 Mar 2014 10:39:14 GMT

You need to create your GJ_Woche so that it is numeric, e.g. by using

Dual(WeekYear(Date) & '/' & Week(Date), WeekStart(Date) ) as GJ_Woche

Then you need to set the axis to be "Continuous" in the graph. (Properties - Axes)

HIC

Re: Chart: x-Axis with clustered/dynamical legend

Fri, 14 Mar 2014 10:57:53 GMT

Hi Stefan,

If you need x-axis values to be exactly horizontal, you should follow what Henric has mentioned.

But if you are fine with the values being displayed vertically or little slanted then you can right click on chart, go to Properties--Axes tab. Then in the Dimension Axis section, you can change the "Primary Dimension labels" to "|" or "/" as required.

Hope this helps!

Re: Chart: x-Axis with clustered/dynamical legend

sunilkumarqv — Fri, 14 Mar 2014 11:01:51 GMT

For simplicity change Primary Dimension labels For more over script you need to put efforts