
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Comparison of two seperate Datasets
Hi, I don´t know how to name my topic prperly, but i hope that I can give a clear description of my problem. I´m no expert, so I have no idea where to start with...
So, on the one hand I have a table where I have loaded all Groups of our Active Directory and a corresponding table with all Members of the AD. Let´s say the table with the groups contains a group named "TS_USERS".
(By the way, I used this Cookbook to load the elements from the AD: )
http://qlikviewcookbook.com/recipes/download-info/load-users-and-groups-from-active-directory/
When I select a certain group in the group-table, all members of this group are displayed in the member-table
On the other hand, I have a table where all users of a specific Oracle-Database are loaded. This table is not linked to the AD-Data. The users in this table all have a status, let`s say "active" or" inactive". Let´s assume the name of the table is "SYS_USERS".
What I want to do now is a query, which provides the following information: List all the users, who are members of SYS_USERS and have the Status "active" but are not members of the AD-group "TS_USERS". (To clarify: A user, who is not member of the group TS_USERS must not have status "active" in the "SYS_USERS"-Table)
I hope this is understandable. Since there is no link between the two Datasets, i can´t use a SQL-Query. So i wonder, if there are any functions in QS, that i can use.
Thanks in advance!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Update, maybe the problem gets clearer then:
I have two filterboxes (A and B) now with mostly the same content, and only a few differences. Now i would like to have a third box (or a table, diagram, whatever...) which lists all the elements, that is present in filterbox B but not in Filterbox A. Any Ideas?
.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@schmimla21 From what you describe, it would seem to me that is going to require Set Analysis, here is a Design Blog post that may be of some help and the Help Doc link below that:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
The only other way to go at it would be to load all the data into your data model and be sure the tables are connected appropriately such that you can get the resolution you want that way. Hopefully this may get you on the right track.
One more Help link for you:
Regards,
Brett
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
