Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wcoleman0908
Partner - Contributor III
Partner - Contributor III

Set Analysis not returning the desired results

I've been unsuccessful in getting this stuburn code to work correctly. What I'm attempting is to return is all records where:

1) The [project status] is open

2) Return those projects where NO projects have any values with a  [completion status] equal to 'In_Prog'

The problem is that it returns projects but includes those projects with 'In_Prog' data values. My task is to Complete those projects that are open that are no longer 'In_Prog'

My set Analysis is as follows:

Count(aggr(Count({<[Project Status]={'Open'},[Completion Status]-= {'In Progress'}   > }distinct [Projects]), [Projects))

I included a sample data file for testing, Any insights would be great

Labels (1)
10 Replies
coleturegroup
Contributor III
Contributor III

=count(Aggr(Only({$<[Project Status]={'Open'}, [Projects] = E({<[Completion Status]={'In Progress'}>} [Projects])>} Group, [Completion Status]), [Completion Status]))


Thanks but unfortunately it didn't work as desired. Maybe i need to add more detail to show my results.

I included the updated QVF file, the table below show only show the following results:

Group C should only show project 7300, 8728

Group E should only show project 9035, 9163

Group F should only show project 6753, 8605

The Aggr seems to not be formed properly, can you see the issue?

Thanks in advance for all your help