1 Reply Latest reply: Nov 28, 2011 10:43 PM by quickview RSS

    Calculated Dimension

      Hi all,

       

      what´s the correct sentence to create this espresion:

       

       

      (RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=.95,'C',

       

       

      if

       

      (RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=0.80,'B',

      if

      (RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))>=.50,'A',

      if

      (RangeSum(Above(SUM({$<AGRUPADOR={'01_VENTAS'}>}(DATA_AVER))/SUM({$<AGRUPADOR={'01_VENTAS'}>}total DATA_AVER) , 0, NoOfRows()))<=0.50,'AA'))))

      as a Dimension?

      Thanks!!

        • Calculated Dimension

          Hi javierortiz,

           

          It might be a good idea to test the expressions in your Qlikview file first?

           

          And see whether there are any red color underlines beneath the expression.

           

          If so you'll know where it goes wrong.

           

          Hope this can help a bit.