21 Replies Latest reply: Dec 1, 2017 12:50 PM by Russell Glenn RSS

    Dimension Calculation to exclude product lines

    Russell Glenn

      Hello,

       

      We have a certain dimension calculation that displays the correct amount of product lines for our revenue calculation. We have been tasked with excluding certain product lines from the data in qlik and are stuggling with combining the two formulas.

       

      =aggr(if(sum(wRevenue)>0 or sum(wRevenue)=0,
      [wProduct Line]=-{"Apple","Oranges"},[wProduct Line], ))

       

      In essence we want to exclude apples and oranges but keep the aggr function working. Original agg function was:

       

       

      =aggr(if(sum([wIOI])>0 or sum(wIOI)=0, [wProduct Line]),[wProduct Line])

       

      Thank you so much for your time.