2 Replies Latest reply: Apr 23, 2013 10:10 PM by Gerald Tagudando RSS

    Can we use an expression as {'filter'} for set analysis?

      Hi Guys,


      I would like to ask for your help regarding my problem. My client will be very happy if you can help me out.


      Question: Can we use an expression as filter for set analysis?

      To explain my question, here is an example:









      ASP = COS * Volume * Investment / 1000



      To count the groups with ASP > 300000


      The catch:

      Each column came from different tables, they cannot be joined / concat


      Ideally, this expression below should fix the issue:

      Count ({$<ASP={>300000}>} DISTINCT Group)


      But as I said before, they came from different tables so using ASP =  COS * Volume * Investment / 1000 in the load script does not work.

      This is actually what I have in mind although the output is wrong:


      If (COS * Volume * Investment / 1000 > 300000, Count (DISTINCT Group))



      We can use an expression in IF statement to filter the result but the question is: Can we use an expression as filter in a set expression?

      Also, it would be great if you can give the correct expression to get the groups with ASP > 300000.


      Thank you very much and Godbless!