set analysis query

[SunilChauhan]

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.

[#2]

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

[SunilChauhan]

then why are considering / and + as two set operators

[#4]

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.

[SunilChauhan]

thanks pk .

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