Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prathipsrinivas
New Contributor III

Finding intersection counts using Set Analysis

Hi Qlikers,

I have an requirement where I would need to show number of users who fall in both category.

For Example, Consider I have a table like

Name, Category

A, User

B,Developer

c,Developer

A,Developer.

Here, I want to show A as an output since A falls in both the categories.

It would be much appreciated if anyone could throw lights on it.

Regards,

Prathip

 

Labels (1)
1 Solution

Accepted Solutions

Re: Finding intersection counts using Set Analysis

May be something like this

{<Name = p({<Category = {'User'}>})*p({<Category = {'Developer'}>})>}
2 Replies

Re: Finding intersection counts using Set Analysis

May be something like this

{<Name = p({<Category = {'User'}>})*p({<Category = {'Developer'}>})>}
Highlighted
prathipsrinivas
New Contributor III

Re: Finding intersection counts using Set Analysis

Thanks Sunny, It worked.

Community Browser