topic Re: How to write this set analysis in QlikView

How to write this set analysis

Mon, 15 Apr 2013 09:48:14 GMT

Hi ALl,

I have one table:

MemberId, Category

1, A

1, B

2, A

2,B

3,C

I want to use one set analysis in Pivot table to show how many Customers who bought both Category A and Category B?

Can you help me out?

kaushiknsolanki — Mon, 15 Apr 2013 11:48:55 GMT

Try this,

Count({<MemberId = p({<Category = {"A"}>}),Category = {"B"}>}Distinct MemberId)

Regards,

Kaushik Solanki

swuehl — Mon, 15 Apr 2013 11:55:16 GMT

Try

=count({<MemberId =p( {<Category ={A}>})*p( {<Category ={B}>}) >} DISTINCT MemberId)

VishalWaghole — Mon, 15 Apr 2013 13:57:16 GMT

Hi,

PFA Hope this will work for you..

Thanks

Vishal