intersect two fields

[QSense]

Hello everyone ,

I have a question about intersection . İn set analysis with element fucntion p It can be done but

I couldnt .

I have two fields and I would like to count two fields's intersection

A and B are fields

I want count(A intersects B)

[#2]

Hi,

The intersection is done by the the star : *

count({{A} * {B}}, xxx)

where {A} and {B} are two sets.

Fabrice

[somenathroy]

Count(DISTINCT{<A=P(B)>}A)

Regards,

Som

[QSense]

When I take your script into my qw file,

It gives not responding error

[#5]

Count(A&B)

[somenathroy]

P(B) returns all possible values of field B. If your table contains huge amount of records, it may arise considerable performance issue. So according to requirements you may impose some conditions through set within P() func, like Count(DISTINCT{<A=P({<Date={'$(=Max(Date))'}>}B), Date={'$(=Max(Date))'}>}A)

Regards,

som