6 Replies Latest reply: Jan 24, 2018 1:02 PM by Ricardo gerhard RSS

    Aggr function with if - Qlik Sense

    ruti t

      Hi everyone,

       

      I try to perform the following expression (aggr function in if conditional) but it doesn't work:

       

      if(GetFieldSelections([Select Type])='Region',Region,

      aggr(if(isnull(NAME),'Other',NAME),NAME))

       

      Could you please advise?

       

      Thanks,

      Ruti.