Union with Set Analysis - Again

[quilldew]

Hi,

I have an issue where I am looking at the union of two sets, both stipulated within the same expression, and filters are only being applied to the first part of the union.

I've attached an example with 2 version of set analysis, both producing weird results. When selecting any ID that is not 'E' I would expect the bottom two tables to match the top table, and exclude any count for 'E'. The filter is only applying to the first part of the Union.

I've changed the extension for the attached file, please change it back to .qvw and it should work. We can't attached .qvw's anymore?

[sunny_talwar · Accepted solution]

Try like this

sum(
{<
 ID -= {'E'}
>
+
<
 ID *= {'E'}
,Year -= {'2001'}
>}
Amount)

BTW very smart way to share your qvw 🙂

[nithin149]

---

{< ID -= {'E'} > + < ID *= {'E'} ,Year -= {'2001'} >} Amount)

Hi sunny,

What does the Star indicate in the set analysis?

Thanks 

Nithin

[sunny_talwar]

Look here on information about *

Implicit Set Operators

[quilldew]

Awesome thanks Sunny, and very useful reading too 🙂