topic Major & Minor Unit In Chart X-Axis in QlikView

Major & Minor Unit In Chart X-Axis

Anonymous — Wed, 11 Jul 2012 11:29:20 GMT

Hi,

I need help in formatting the X Axis of a chart. Here is the table on which I am creating the chart.

Here you can see every year has 4 entries, But in the below chart we are showing only one entry for each year.

Using the above table I have created a chart in excel.

Here in the chart you can see I have used major and minor units to hide 3 entries of each year. Only march month for each year is displayed in the chart axis and the june, sep, dec is shown as the minor unit. Now I am trying to do the same in Qlikview which is I am not able to do.

I am trying to use a scroller to scroll through the years, but as you can see 2012 is repeating 4 times. Is it possible to show only the starting of each year in major unit and rest in minor unit. Please help

Re: Major & Minor Unit In Chart X-Axis

jagan — Wed, 11 Jul 2012 11:39:38 GMT

Hi,

Check this file, hope it helps you.

Regards,

Jagan.

Re: Major & Minor Unit In Chart X-Axis

Anonymous — Wed, 11 Jul 2012 12:04:49 GMT

Thank you Jagan, but this is not solving the issue.

Re: Major & Minor Unit In Chart X-Axis

jagan — Wed, 11 Jul 2012 12:42:02 GMT

Hi,

Instead of using calculated dimension to arrive year, get year as dimension in Script. I think this solves the issue.

If not can you attach sample file.

Regards,

Jagan.

Re: Major & Minor Unit In Chart X-Axis

Anonymous — Wed, 11 Jul 2012 13:57:38 GMT

Attached is the sample file...

Re: Major & Minor Unit In Chart X-Axis

Anonymous — Wed, 11 Jul 2012 13:58:23 GMT

The MAX VISIBLE NO is set to 10 as I have to show 10 years records only