Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

quilldew
Contributor

Union with Set Analysis - Again

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?

1 Solution

Accepted Solutions

Re: Union with Set Analysis - Again

Try like this

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

BTW very smart way to share your qvw 🙂

4 Replies

Re: Union with Set Analysis - Again

Try like this

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

BTW very smart way to share your qvw 🙂

nithin149
New Contributor II

Re: Union with Set Analysis - Again

 


{< 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

Look here on information about *

Implicit Set Operators

Highlighted
quilldew
Contributor

Re: Union with Set Analysis - Again

Awesome thanks Sunny, and very useful reading too 🙂