7 Replies Latest reply: Jul 25, 2018 11:52 AM by Sunny Talwar RSS

    Nested Set Analysis Help

    Kenneth Holden

      Aggr(Rank(Sum({<AGENT_LAST_NAME>} UNITS)), {<LEAD_SOURCE-={'DAT'}>} AGENT_LAST_NAME)

       

      THis is an expression designed to provide the agents RANK in new business only, excluding database(existing customers).

       

      the aggr formula works independently, but when I add the second set analysis to tell qlik to exclude the units that are "dat", it gives me no result.

       

      what did I do wrong?

       

      thank you