9 Replies Latest reply: Sep 25, 2017 1:55 AM by Anil Samineni 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?