topic Re: join in set analysis in QlikView

join in set analysis

Wed, 19 Dec 2012 13:34:28 GMT

Hi,

I'm trying to make a join in a set analysis.

For example, i've 2 tables:

T1:

T2:

I need to count the rows where there are a match between code_t1 and code_t2, here 2 rows.

I try this but without success:

count(DISTINCT {<code_t1=P(code_t2)>} id_t1)

I can't rename the column to make an association.

thanks for your help

Wed, 19 Dec 2012 13:52:26 GMT

I tryied the next proposition:

count(DISTINCT {<code_t1={'=code_t1=code_t2'}>} id_t1)

unfortunately without success, i've no data to display as result

Gysbert_Wassenaar — Wed, 19 Dec 2012 13:54:07 GMT

This one works for me: =count( {<code_t1=p([code_t2])>} DISTINCT id_t1)

Not a set analysis expression, but it returns the correct count too: =count(DISTINCT if(code_t1=code_t2, id_t1))

Wed, 19 Dec 2012 13:57:43 GMT

Your solution was good:

=count(DISTINCT if(code_t1=code_t2, id_t1))

thanks