Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
New Contributor III

Set analysis

Hi,

I need to make a special selection inside a table and I understand this is called set analysis, can you please help me to figure out the following?

I have two data sets, one set with requests and one with assignments (accepted requests, not rejected).

Once a request has been turned in to an assignment it keeps its number so the two sets of data have almost the same numbers. The ones excluded are the rejected requests.

How can I show only the accepted request in my table, i.e I want to show all assignment numbers that exist both in the request and the assignment data set.

Thanks!

2 Replies
MVP
MVP

Re: Set analysis

Do you have flags for those assignments? If you do then the things can be very easy:

{<Flag = {'Accepted'}>}

If not, can you create them easily? I have no familiarity with the data, so can't give a more detailed response

ali_hijazi
Honored Contributor

Re: Set analysis

or you can left join two tables on the request number during the join add a column say 'Accepted' as Flag

left join(Set1)

load request_number , 'Accepted' as Flag

resident Set2;

drop table Set2;

then in the set analysis your expression would look something like this:

count({<Flag={'Accepted'}>}Requests)