Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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

View solution in original post

6 Replies
YoussefBelloum
Esteemed Contributor

Re: Comparing two selections in one table

Hi,

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

Highlighted
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

View solution in original post

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.