5 Replies Latest reply: Jun 28, 2013 7:34 AM by Nitin Gupta RSS

    Calculation of active and inactive values in pivot table

      Hello all,

       

      I am new to qlikview

      I was working on a report where I have to show count of non-zero values as active and zero values as inactive in pivot table.

      when dealing with multiple dimensions , if they are in rows then the values calculated in script works as in chart I

      But when I transpose one dimension to column , then this fails as in chart II

       

      I have attached  the qvw file for reference ....

       

       

      Plase help me out in this case.

      Thanks for considerations and support