Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
The intersection is done by the the star : *
count({{A} * {B}}, xxx)
where {A} and {B} are two sets.
Fabrice
Count(DISTINCT{<A=P(B)>}A)
Regards,
Som
When I take your script into my qw file,
It gives not responding error
Count(A&B)
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