1 Reply Latest reply: Dec 7, 2011 10:44 AM by Fernando Suzuki RSS

    ColumnNo() Error in Set Analysis

      Hi,

       

      I have this script in a pivot table.

       

      count({<EffectiveYear={2011},EffectiveWeek={$(=ColumnNo())}>} TOTAL [Employee Number])

       

      But unfortunately, ColumnNo() is not recognized properly by set analysis.

       

      I have tried placing RowNo() and it works as well as placing constant.

        • ColumnNo() Error in Set Analysis
          Fernando Suzuki

          Hi,

           

          I think that the problem is that QlikView first evaluates the Dollar-Sign Expansions to get the final expression, and after tries to calculate the value for each row/column. So QlikView is using the following expression:

          count({<EffectiveYear={2011},EffectiveWeek={-}>} TOTAL [Employee Number])

          , which returns you invalid data.

           

          Trty replacing the expression for this:

          count({<EffectiveYear={2011}, HireWeek=p(EffectiveWeek)>} [Employee Number])

           

          I'm not sure of what you want, so it may be incorrect....

           

           

          Hope this helps you.

          Regards,

          Fernando