4 Replies Latest reply: Mar 30, 2016 9:18 AM by Stefan Wühl RSS

    Expression based on condition

    Tim Janse
      dim1productpriceamounttotal
      xxxA224
      xxxB616
      xxxC339

       

      I want to hide price and amount from product B and only show totals for the products A en C, i cant figure this out in Qlikview.
      any suggestions?

       

       

       

      Im using a pivot table with three expressions:

       

      Amount:

      (sum(amount)/count(DISTINCT Month))

       

      Price:

      (sum(total))/

      (sum(amount)/count(DISTINCT Month))

       

      total:

      sum(total)