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: 
Not applicable

Set analysis help!

Hi,

I am trying to work on a set analysis expression which is not giving me the desired results.

On the 'Non continuers' table/chart, I should get a results of 6 Non continuers, but my expression keeps giving me 5.

I basically need to show all students/student IDs where they studied in Year 09, AND don't continue in 2010(AcYr 201011).

So, it must distinct count the Stu_Prog where the studentID is in 2009, but not in 2010.

My continuers table/chart seems to be giving me the correct results.

I have attached the .qvw I am using.

Any help would be much appreciated!

Thanks.

1 Reply
lironbaram
Partner - Master III
Partner - Master III

hei

attach is your example with the correct result

what i did is changing the set analsys a lttle

hhave a look inside the formula

hope its helps you