topic Re: Tablelink via KeyField deletes Values i Need. (exclude) in QlikView

Tablelink via KeyField deletes Values i Need. (exclude)

alexander__ — Fri, 01 Jul 2016 10:02:48 GMT

I have a table in which I create a Composite key . This would be my main table , here are more data than in the second table which also owns the composite key . Once the two tables are connected via keys in the data model , the items are only available , which occur in both tables . I would but the entries from my main table also need if for this key in the second table , no entries are available for this . How can I make this?

MainTable 2nd Table

Eintrag1 Eintrag1

Eintrag2

Eintrag3 Eintrag3

i need Eintrag2 although it is not in Table2.

Actually i got only this

MainTable 2nd Table

Eintrag1 Eintrag1

Eintrag3 Eintrag3

Re: Tablelink via KeyField deletes Values i Need. (exclude)

shree909 — Fri, 01 Jul 2016 17:55:13 GMT

How your joining the tow compoiste keys, if your making outer join then it should work.

can you share the app to dig into it.

Re: Tablelink via KeyField deletes Values i Need. (exclude)

maxgro — Fri, 01 Jul 2016 19:08:19 GMT

I think you can show all the items, also the items in one table

See the attachment or post a small example with your problem