Master/Detail

[#1]

I have 2 table with 1->0:n relation.

Table 1:

-Year
- KEY1
...

Table 2:

- KEY2
- KEY1 (foreign Key)
...

What can I create a graph with:

DIMENSION : YEAR

EXPRESSION: Number of records on Table 1 don't have corrispondence on Table2

Thans

[#2]

You can use the set analysis to accompolish this by using something like this

sum({1-$} Key1)

Please refer to Set analysis is reference Manual

Talha

[#3]

Thank you but I can't use Set Analysis.

I'll be more clear,

TAB1
YEAR	KEY1
2008	A
2008	B
2009	C
2009	D
2009	E
TAB2
KEY2	KEY1
A1	A
A2	A
A3	A
A4	A
C1	C
D1	D
D2	D
Result
YEAR	Nr rec TAB1	Nr Rec Unmatched
2008	2	1
2009	3	1

[#4]

Maybe this will help you

let me know if this is the solution you want

Talha

[#5]

Ok, it's I can use nullcount (I didn't know that operator) but, in order to use it, I have to concatenate on tab2 the not exists key1.

Thanks a lot

Bye