topic Re: Comparing two selections in one table in QlikView

Comparing two selections in one table

florianmay — Wed, 25 Nov 2020 16:16:04 GMT

Hello!

I load data from active directory and made a table like this:

Now i want to compare the groups of two users. In best case i want a field or table, which only shows me the rows with different groups.

For example, I compare U1 with U2:

Is it possible to compare two selections like this?

best regards,

Florian

YoussefBelloum — Tue, 13 Mar 2018 10:15:13 GMT

Hi,

on your second table, are missing the line: U1, G1 ?

florianmay — Tue, 13 Mar 2018 10:17:31 GMT

U1->G1 and U2->G1 should not be shown, because both users are members of G1

YoussefBelloum — Tue, 13 Mar 2018 12:51:01 GMT

I'm stuck on this one, when you have some time to help please take a look

sunny_talwar — Tue, 13 Mar 2018 12:55:53 GMT

May be using a set analysis like this?

{<Group = {"=Count(DISTINCT User) = 1"}>}

YoussefBelloum — Tue, 13 Mar 2018 13:07:03 GMT

Perfect !

florianmay — Wed, 14 Mar 2018 06:56:16 GMT

Thanks, this works great.