topic Finding intersection counts using Set Analysis in QlikView

Finding intersection counts using Set Analysis

prathipsrinivas — Sat, 16 Nov 2024 04:58:10 GMT

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 — Thu, 13 Dec 2018 15:41:18 GMT

May be something like this

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

prathipsrinivas — Fri, 14 Dec 2018 07:31:45 GMT

Thanks Sunny, It worked.