topic Master/Detail in QlikView

Master/Detail

Fri, 05 Jun 2009 22:15:38 GMT

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

Fri, 05 Jun 2009 22:30:08 GMT

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

Fri, 05 Jun 2009 23:14:01 GMT

Thank you but I can't use Set Analysis.

I'll be more clear,

Sat, 06 Jun 2009 01:55:53 GMT

Maybe this will help you

let me know if this is the solution you want

Talha

Mon, 08 Jun 2009 14:25:38 GMT

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