Compairing Same Data from Different Years

[Anonymous]

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.

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!

[tomasz_tru]

You'd better use set analysis and P() function:

Set modifiers with implicit field value definitions ‒ Qlik Sense

[balar025 · Accepted solution]

Hi,

Please find attached application

-Ravi Balar

[Anonymous]

Thanks a lot! That worked perfectly!