Tablechart listing Data which has no related Data in other Tables

[#1]

Hi everyone,

I want a chart, where all "Partner_Adressnummer" are listed, who have no Data in the Table "Seminarbuchungen"

I thought, maybe with this formula:

=only({1-$<SeminarBuchungsID={'0'}>} Partner_Adressnummer)

But that did not work.

Has anybody an idea?

Tablerelations as screenshot enclosed.

Regards

Michael

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

I'd rather try using the E() element expression in set analysis, something like

Only({< Partner_Adressnummer = E(SeminarBuchungsID) >} Partner_Adressnummer)

that reads like "return the values in field Partner_Addressnummer that have all values in SeminarBuchungsID excluded".

What type of chart are you using? What are the dimensions?

Hope that helps.

Miguel

EDIT:

Other option more likely to work:

Only({1 - < SeminarBuchungsID = P(SeminarBuchungsID) >} Partner_Adressnummer)

that reads like "return all values in dimension Partner_Adressnummer except for those that have some SeminarBuchungsID".

[#3]

Thanks, the second solution was very helpful