how to compair values

[Anonymous]

Hi, very new to qlik!

I'm looking for the way to compair values between two years.

I have a table with the area of parcels in 2006 and 2016 and I want to know how much the sum of the area for each zone has changed

area

area	zone	parcel	year
20	x	a	2016
30	x	a	2006
60	y	b	2016
40	y	b	2006
10	x	c	2016
10	x	c	2006

Could you tell me how to write the function to get " sum(area zone x 2016)- sum (area zone x 2006) " per parcel. and to be able to use this as a mesurement  (if that is the right translation)

Thank you so much, i feel if I get this i'll be able to do so much more and I'm having a hard time finding it in the help recources.

[beck_bakytbek · Accepted solution]

Hi Marloes,

try this:

Sum({<Year ={'2016'}, Zone = {"x"}>}Area) - Sum({<Year ={'2006'}, Zone = {"x"}>}Area)

beck

[OmarBenSalem]

Beck's answer is correct.

You can also check this thread in which I tried to explain set analysis in an easy way:

YTD, MTD issue

[Anonymous]

hi, I was too fast with saying it was the right answer, wel it was the right answer for my question but I now realise that I want to have the 'zone' to be a variable.

In such a way that i can use it as a variable to give my kml file nice colours.

am I making sense?

[Anonymous]

found it, just had to delete the Zone = {"x"} from the formulla.

thanks you thank you!!