5 Replies Latest reply: Aug 16, 2012 6:06 AM by nessinot RSS

    Hide unused dimension values in chart

      I have the following simplified dataset:

       

      Month:
      LOAD * INLINE [
          Year, Month
          2011, 2011-01
          2011, 2011-02
          2011, 2011-03
          2011, 2011-04
          2011, 2011-05
          2011, 2011-06
          2011, 2011-07
          2011, 2011-08
          2011, 2011-09
          2011, 2011-10
          2011, 2011-11
          2011, 2011-12
          2012, 2012-01
          2012, 2012-02
          2012, 2012-03
          2012, 2012-04
          2012, 2012-05
          2012, 2012-06
          2012, 2012-07
          2012, 2012-08
          2012, 2012-09
          2012, 2012-10
          2012, 2012-11
          2012, 2012-12
      ];
      Sales:
      LOAD * INLINE [
          Month, Sales
          2011-01, 100
          2011-02, 500
          2011-03, 100
          2011-04, 200
          2011-05, 900
          2011-06, 300
          2011-07, 200
          2011-08, 600
          2011-09, 800
          2011-10, 300
          2011-11, 500
          2011-12, 100
          2012-01, 400
          2012-02, 400
          2012-03, 700
          2012-04, 400
          2012-05, 200
          2012-06, 600
          2012-07, 300
          2012-08, 100
      ];
      

       

      I have created a chart from this with Month as a dimension and the following two expressions:

       

      Sales 2012:

      SUM({<Year = {"2012"}>}Sales)

       

      Sales 2011:

      SUM({<Year = {"2011"}>}Sales)

       

      The Sales 2012 expression has the following display options:

      DisplayOptionsBar.JPG

       

      The Sales 2011 expression has the following display options:

      DisplayOptionsNone.JPG

       

      It is my intention to get a bar chart which only shows the sales of 2012. But when the user clicks a fast change the user would get a table which shows the sales of 2012 and 2011.

       

      This is what I would like to have my chart to look like:

       

      ChartWanted.JPG

       

      But it actually looks like this:

       

      ChartActual.JPG

       

      When I do the fast change the straight table looks like this:

       

      StraightTable.JPG

       

      How can I remove the 2011 months from my bar chart, but still get the straight table as displayed above when I do a fast change?

       

      The Suppress When Value Is Null option in the Dimensions tab does not work in this case. Is there another option that I have overlooked that can hide the 2011 months from the X axes?

       

       

       

      I have attached BarChart.qvw which implements the dataset and barchart described above.