Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
maprinci
Not applicable

Help with set analysis - select accounts that own only certain product(s)

Hello,

I have a data set like the following:

AccoutNum    Product

1                       A

1                       B

1                       C

2                       A

2                       D

3                       A

4                       C

4                       E

4                       F

I am interested in getting the total number of accounts that own only Product A or only Products A and C, etc.  When I use a filter for Product and select A, I get all accounts that own Product A but also potentially own other products.  Basically,  I need to isolate groups of products where an account owns nothing but the product(s) I select.  Any help is appreciated.

Thanks!

1 Solution

Accepted Solutions
ahaahaaha
Not applicable

Re: Help with set analysis - select accounts that own only certain product(s)

Hi Melissa,

See attached file. Maybe something like this?

Regards,

Andrey

3 Replies
ahaahaaha
Not applicable

Re: Help with set analysis - select accounts that own only certain product(s)

Hi Melissa,

See attached file. Maybe something like this?

Regards,

Andrey

maprinci
Not applicable

Re: Help with set analysis - select accounts that own only certain product(s)

Thank you, Andrey!

maprinci
Not applicable

Re: Help with set analysis - select accounts that own only certain product(s)

Andrey,

Do you know of a way to easily update this to also display only accounts that do not own certain product(s)?  I would want the user to be able to select a product and have only accounts that do not own that product appear with the products they do own.  I have tried using the E() function in a few different ways but have not gotten anything to work yet.

Thank you,

Melissa