Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

anuragsapanbhar
New Contributor III

Major & Minor Unit In Chart X-Axis

Hi,

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

tbl.png

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.

Exl.png

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.

QV.png

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

5 Replies
MVP
MVP

Re: Major & Minor Unit In Chart X-Axis

Hi,

Check this file, hope it helps you.

Regards,

Jagan.

anuragsapanbhar
New Contributor III

Re: Major & Minor Unit In Chart X-Axis

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

MVP
MVP

Re: Major & Minor Unit In Chart X-Axis

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.

anuragsapanbhar
New Contributor III

Re: Major & Minor Unit In Chart X-Axis

Attached is the sample file...

Untitled.png

anuragsapanbhar
New Contributor III

Re: Major & Minor Unit In Chart X-Axis

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

Community Browser