3 Replies Latest reply: Jul 7, 2017 7:03 AM by Marcelo Lapertosa RSS

    Compairing Same Data from Different Years

    Marcelo Lapertosa

      I'm trying to compare the qty sold of items, but I only want to see on my Pivot Table the items that repeat in both 2016 and 2017, how should I do it?

       

      So in the example below, I want to see only item 553, since it sold both in 2016 and 2017 while 554 only sold in 2016.

      QlikView Help.png

      I'm currently using 2 expressions like this:

      Sum(If(Year='2016', QTY))

      Sum(If(Year='2017', QTY))

       

      I tried using AND as in Sum(If(Year='2016' AND SUM(IF(Year='2017',QTY) ) <> 0, QTY)), but it didn't work. Any idea?

       

      Thanks!