topic Re: two subsets - i need the intersection in QlikView

two subsets - i need the intersection

Wed, 28 Aug 2013 11:22:27 GMT

Hi at all,

i have following question:

I have two Dimension with results:

Example:

I need a Count of the Intersection between Dimension A and Dimension B:

For this Example it is A - A, C - C and A - A. I need to count the distinct pairs. In this example the Distinct Count = 2 becaus A - A and C - C.

Which formula is correct?

I tried something like this without success:

"COUNT( ({<DimensionA>*<DimensionB>}) DISTINCT DimensionA)

Thank You!!!!

CELAMBARASAN — Wed, 28 Aug 2013 11:29:09 GMT

Both the fields are in same table?

Wed, 28 Aug 2013 11:50:51 GMT

yes

mdmukramali — Wed, 28 Aug 2013 12:14:32 GMT

Dear kstyles089,

Try the below two expressions

=count({<DimensionA={"=count({< DimensionB=P(DimensionA)>}distinct DimensionA)>0"} > }distinct DimensionB)

=count({<DimensionB={"=count({< DimensionA=P(DimensionB)>}distinct DimensionB)>0"} > }distinct DimensionA)

kindly find the attachment.

I hope it will help you.

Thanks,

Mukram.

Thu, 29 Aug 2013 07:55:48 GMT

Dear Mukram,

thanks a lot!

But sry... My mistake. The two dimension are not in one table.

The Tableview looks like following example:

so your expression doesn`t work. Do you have a solution for this problem?

thanks, kstyles089

mdmukramali — Thu, 29 Aug 2013 07:59:06 GMT

can you attach the sample file.

Thanks,

Mukram

CELAMBARASAN — Thu, 29 Aug 2013 08:13:57 GMT

Hi,

I hope the attachment helps