Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
quilldew
Creator
Creator

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
sunny_talwar

Try like this

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

BTW very smart way to share your qvw 🙂

View solution in original post

4 Replies
sunny_talwar

Try like this

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

BTW very smart way to share your qvw 🙂

nithin149
Contributor II
Contributor II

 


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

Awesome thanks Sunny, and very useful reading too 🙂