Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
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.
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.
Thanks a lot! This works perfectly 🙂
Best regards,
Diana