topic Re: how to compair values in Visualization and Usability

how to compair values

Anonymous — Thu, 13 Apr 2017 11:02:53 GMT

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.

Re: how to compair values

beck_bakytbek — Thu, 13 Apr 2017 15:55:03 GMT

Hi Marloes,

try this:

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

beck

Re: how to compair values

OmarBenSalem — Thu, 13 Apr 2017 16:14:04 GMT

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

Re: how to compair values

Anonymous — Fri, 14 Apr 2017 08:12:49 GMT

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?

Re: how to compair values

Anonymous — Fri, 14 Apr 2017 13:18:16 GMT

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

thanks you thank you!!