9 Replies Latest reply: Sep 25, 2017 1:55 AM by Anil Babu RSS

    Hide excluded with Aggr & if isnull in qlik sense

    ar eiuiew

      I want to hide excluded (not associated) values from a list, I usually do it with aggr function like this:

       

      Aggr(Column, Column)

       

      But now I need to do it for a calculated dimension, my dimension is :

       

      If(isnull(ColumnB)=0, ColumnA)

       

      I tried

      Aggr(If(isnull(ColumnB)=0, ColumnA) , If(isnull(ColumnB)=0, ColumnA) )


      But It's not working, any recommendation?


      Thanks