Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You'd better use set analysis and P() function:
Set modifiers with implicit field value definitions ‒ Qlik Sense
Hi,
Please find attached application
-Ravi Balar
Thanks a lot! That worked perfectly!