7 Replies Latest reply: Jan 27, 2012 6:19 AM by Robert Svebeck RSS

    Uncheck "supress zero values" in my Extension object ?

    Robert Svebeck

      Hi.

       

      Again, possibly a simple question from a novice...


      In a ordinary chart, I can uncheck "Supress zero values" which will let me see all dimensions even if the expression has nothing to calculate for a specific value in the dimension.


      If I have two tables like this:


      TableA
      ID, Descr
      A,  Alfa
      B,  Beta
      C,  Gamma


      TableB
      ID, Qty
      A, 10
      A, 20
      A, 50
      B, 10
      B, 40


      I make a simple chart with a simple sum(Qty) expression, and with ID as dimension.
      I uncheck "Supress Zero values" -> I will see all three values of ID (A,B,C) and the sum of Qty for each (80,50,-)


      I can not find how to uncheck "supress zero values" in my extension object. When I loop my data like this:


      for (var rowIx = 0; rowIx < myData.Rows.length; rowIx++)
      {
      var row = myData.Rows[rowIx];
      alert (row[0].text + " - " + row[1].text);
      }


      I see that I get only 2 rows, A and B and nothing at all for dimension 1 value C. This is kinda expected behaviour for a normal chart when "supress zero" is checked, but How do I not supress zero values for a extension object?

      Best Regards,

      Robert Svebeck