Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

prathipsrinivas
Contributor

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
Contributor

Re: Finding intersection counts using Set Analysis

Thanks Sunny, It worked.