Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

florianmay
New Contributor II

Comparing two selections in one table

Hello!

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

UserGroup
U1G1
U1G2
U2G1
U2G3
U2G4
U3G3

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:

UserGroup
U1G2
U2G3
U2

G4

Is it possible to compare two selections like this?

best regards,

Florian

1 Solution

Accepted Solutions

Re: Comparing two selections in one table

May be using a set analysis like this?

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


Capture.PNG

6 Replies
YoussefBelloum
Esteemed Contributor

Re: Comparing two selections in one table

Hi,

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

florianmay
New Contributor II

Re: Comparing two selections in one table

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

YoussefBelloum
Esteemed Contributor

Re: Comparing two selections in one table

Hi stalwar1

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

Re: Comparing two selections in one table

May be using a set analysis like this?

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


Capture.PNG

YoussefBelloum
Esteemed Contributor

Re: Comparing two selections in one table

Perfect !

florianmay
New Contributor II

Re: Comparing two selections in one table

Thanks, this works great.

Community Browser