3 Replies Latest reply: Jun 17, 2015 8:45 AM by Sunny Talwar RSS

    which performance is better while excluding values in set analysis?

    Ramesh A

      I have below data

      Points:

      LOAD * INLINE [

          Country, Points

          India, 10

          India, 11

          UK, 12

          UK, 9

          USA, 10

          USA, 89

      ];

       

      I want to aggregate points for all countries except India:

      Dimension: Country

      Exp1: sum({Country-={'India'} Points)

      Exp2: sum({Country={*}-{'India'} Points)

       

      If we many columns in a table and using Exp1 and Exp2 methods to exclude any value, which method performs better than that of other. Is it Exp1 or Exp2 method?

       

      -Regards

      Ramesh