Max Funktion mit 2 Restriktionen

[Sahin]

Hallo zusammen,

ich möchte aus einer Tabelle pro Kunde den Max-Wert vom Datum und von der Mahnstufe anzeigen lassen.

Bekomme aber alle Einträge angezeigt. Dabei möchte ich nur jeweils 1 Zeile pro Belegnr.

Versucht habe ich folgendes:

LOAD
Max("Reminder Level",1) as "Reminder Level",
"Posting Date",
Max(date("Document Date")) as "Document Date",
"Document Type",
"Document No_", // as "Fakten_V2.Document No_",
Num("Remaining Amount", '#.###,00'),
'022-' & "Customer No_" as Key_MandNrKDNr,
"Customer No_"
where year("Document Date")> '2024' and "Document Type" = '2'

group by "Posting Date",
"Document Type",
"Document No_",
Num("Remaining Amount", '#.###,00'),
"Customer No_" ;

Viele Grüße

Emre

[Oleg_Troyansky]

Hi there,

It looks like you are confusing the data layer and the presentation layer.

In the data layer, if you wanted to load one row per Document, then your LOAD statement's GROUP BY clause should only include the Document Number, and maybe the Customer and the Document Type, but no dates or amounts - those need to be aggregated with either Sum (for amounts) or Min/Max (for dates).

In the presentation layer, you can define your Dimensions and Measures in a Table any way you want. For example, if you define Document Number as a Dimension and use sum(Amount) and Max(Date) as two measures, you will see one line per Document, with aggregated measures.

Did I answer your questions, or did I miss something?

Cheers,

Oleg Troyansky

P.S. Join my Qlik Expert Class in Vienna on September 22-24 to learn advanced Qlik methodologies.