topic set analysis query in QlikView

set analysis query

SunilChauhan — Mon, 30 Jan 2012 14:23:07 GMT

sum({<Year={2010,2011}>}values)

sum({<Year={2010}+{2011}>}values)

sum({<Year={2010}/{2011}>}values)

what is differencee between above three expression.

i am getting same result on each.

set analysis query

Mon, 30 Jan 2012 14:34:39 GMT

Hi Sunil,

I believe in your case there is no difference between these.

1. You get all the values for year 2010 and 2011.

2. You get the values for year 2010 + values for year 2011 (same as above).

3. In this case the data sets for year 2010 and 2011 are disjoint and the symetrical difference of these will just give you sum of both sets.

Przemek

set analysis query

SunilChauhan — Mon, 30 Jan 2012 14:35:58 GMT

then why are considering / and + as two set operators

set analysis query

Mon, 30 Jan 2012 14:50:21 GMT

It depends on your data set. Symmetric difference will give you all data that is related to the year 2010 and 2011, but not both of them.

So in your case you probably have some values that are related to the year 2010 and some to the year 2011, but you don't have values that are related to the year 2010 and 2011 the same time.

In such case the simmetric difference will give you a sum of these values (the same as + operator).

If these would intersect (some of the values would be related to both year 2010 and 2011) the result of / and + would be different.

set analysis query

SunilChauhan — Tue, 31 Jan 2012 07:55:58 GMT

thanks pk .

But can i have sample file where we can understand the difference.