Finding intersection counts using Set Analysis

[prathipsrinivas]

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

[sunny_talwar · Accepted solution]

May be something like this

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

[prathipsrinivas]

Thanks Sunny, It worked.