topic Re: intersect two fields in QlikView

intersect two fields

QSense — Thu, 03 Oct 2013 07:37:06 GMT

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)

Re: intersect two fields

Thu, 03 Oct 2013 07:43:55 GMT

Hi,

The intersection is done by the the star : *

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

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

Fabrice

Re: intersect two fields

somenathroy — Thu, 03 Oct 2013 07:59:38 GMT

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

Regards,

Som

Re: intersect two fields

QSense — Thu, 03 Oct 2013 08:37:41 GMT

When I take your script into my qw file,

It gives not responding error

Re: intersect two fields

Thu, 03 Oct 2013 08:49:35 GMT

Count(A&B)

Re: intersect two fields

somenathroy — Thu, 03 Oct 2013 09:11:38 GMT

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