5 Replies Latest reply: Jul 11, 2012 9:58 AM by Anurag Bharat RSS

    Major & Minor Unit In Chart X-Axis

    Anurag Bharat

      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