3 Replies Latest reply: Nov 2, 2018 10:37 AM by Jan Lancé RSS

    How to obtain records that only have changes?

    Anna Yudina

      Hi everyone,

       

      I was wondering how could I filter out the records to only the ones that have a price change? Based on the table below, I want to see only the Bread and Milk entries. I'm fairly new to Qlik and I know that there has to be some sort of set analysis. Thank you in advance!

       

       

       

       

      Grocery Item

      2017 Price2018 Price
      Bread$4.00$3.00
      Milk$2.00$1.50
      Eggs$3.00$3.00
      Butter$2.50$2.50