Wrong values after (left) join

Diana_B — Mon, 12 Jul 2021 14:33:26 GMT

Hi!

I am relatively new to QlikView and need your help with following problem:

When joining some fields from another table (see script below) I get wrong values in my pivot-table .

The dimension is [Patienten-ID] and expression in the table is just "sum(Therapieanzahl)" which should be 141 for one particular Patient-ID and after joining the value is 1128.

How can I solve this problem?

If you need further information please let me know.

Thx for your help!

Best regards,

Diana

Gesamtliste: LOAD [Patienten-ID], Therapiedauer_Buchstabencode, Div(Aufenthaltsdauer, 7) as [Aufenthaltsdauer in Wochen], Therapieanzahl, [KTL-Code], Therapieklasse, If(Aufenthaltsdauer>=7,'ja', 'nein') as [Aufenthalt_Berücksichtigung] Resident Gesamt_KTL ; Join LOAD [PatID] as [Patienten-ID], Patient, Fallnummer, Patklasse, Bereich, Bereich_lang Resident Abrechnungsbereich ; DROP Tables Gesamt_KTL, Abrechnungsbereich;

Re: Wrong values after (left) join

kaushiknsolanki — Mon, 12 Jul 2021 17:27:25 GMT

It's because the joining table doesn't have distinct values.

From your code, if you check the table

Abrechnungsbereich

and you will find that it has duplicate values.

Try to remove the duplicate values to get the correct result.

Re: Wrong values after (left) join

Diana_B — Tue, 13 Jul 2021 09:01:53 GMT

Thanks a lot! This works perfectly 🙂

Best regards,
Diana

topic Re: Wrong values after (left) join in QlikView

Wrong values after (left) join

Re: Wrong values after (left) join

Re: Wrong values after (left) join