topic Re: Unmatched Values in QlikView

Unmatched Values

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone,

I have below two tables which are joining based on Id and Value.I want all the choices into answerfact table.

I have a requirement to display all the choices for each Id from choice table though respective values are not available in answerfact table.I want all the records from answerfact table since it is the main fact table.

Choice:

Id value Choice

100 1 A

100 2 B

100 3 C

100 4 D

100 5 E

200 1 A

200 2 B

200 3 C

300 4 D

300 5 E

300 1 A

300 2 B

400 3 C

400 4 D

400 5 E

500 1 A

500 2 B

500 3 C

500 4 D

500 5 E

Answerfact:

Id value Cmp year answerId

100 1 aaa 2016 A01

200 2 bbb 2016 A02

300 4 aaa 2016 A03

600 6 ccc 2016 A01

700 7 ddd 2016 A02

500 1 aaa 2016 A03

500 2 bbb 2016 A01

500 3 ccc 2016 A05

500 4 ddd 2016 A06

500 5 eee 2016 A07

Thanks in advance

Re: Unmatched Values

lironbaram — Wed, 20 Sep 2017 04:17:50 GMT

so you can do

load * Answerfact;

left join (Answerfact)

load * Choice;

this will leave all records from answer fact but will only keep records from Choice where there is a corresponding

record in answer fact

or you can do

load * Answerfact;

join (Answerfact)

load * Choice

this will keep all records from both tables

Re: Unmatched Values

Anonymous — Tue, 26 Sep 2017 03:52:20 GMT

Thanks for your reply.

I want to show all the text though respective Answer values are not available in first table(A)

For Example id 34955 the texts A,B,C,D should display where D,C will not be having any answer value.Instead of displaying all the texts(A,B,C,D,E,F,G,H) in bar chart i want to display only above 4 texts(A,B,C,D) since C,D texts are available from the second table.Similarly for id 34956 i want to display E,F,G ,H.I am doing outer join.

Please find the attached samples.