Discussion board where members can get started with Qlik Sense.
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:
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?
Go to Solution.
Please find attached application
You'd better use set analysis and P() function:
Set modifiers with implicit field value definitions ‒ Qlik Sense
Thanks a lot! That worked perfectly!