topic Re: Union with Set Analysis - Again in QlikView

Union with Set Analysis - Again

quilldew — Wed, 28 Nov 2018 15:12:24 GMT

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?

Re: Union with Set Analysis - Again

sunny_talwar — Wed, 28 Nov 2018 15:20:09 GMT

Try like this

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

BTW very smart way to share your qvw 🙂

Re: Union with Set Analysis - Again

nithin149 — Wed, 28 Nov 2018 22:54:44 GMT

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

Hi sunny,

What does the Star indicate in the set analysis?

Thanks

Nithin

Re: Union with Set Analysis - Again

sunny_talwar — Thu, 29 Nov 2018 01:53:53 GMT

Look here on information about *

Implicit Set Operators

Re: Union with Set Analysis - Again

quilldew — Thu, 29 Nov 2018 10:34:03 GMT

Awesome thanks Sunny, and very useful reading too 🙂