How to obtain records that only have changes?

[Anonymous]

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 Price	2018 Price
Bread	$4.00	$3.00
Milk	$2.00	$1.50
Eggs	$3.00	$3.00
Butter	$2.50	$2.50

[sunny_talwar]

Do you have Prices for 2017 and 2018 in different column like above or do you have a field for Price and a field for Year?

[jan_lance]

Try changing the Dimension "Grocery Item" to a formula:

if(not "2017 Price" = "2018 Price" , "Grocery Item")

Suppress Null values.

Then your dimension will only be filled wenn the prices differ.

[Anonymous]

They are fields