Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
schmimla21
Contributor
Contributor

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!

2 Replies
schmimla21
Contributor
Contributor
Author

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?

Brett_Bleess
Support (Former)
Support (Former)

@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

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...

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:

https://help.qlik.com/en-US/sense/November2020/Subsystems/Hub/Content/Sense_Hub/DataModeling/best-pr...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.