topic Re: Load maximum Date per Dimension in App Development

Load maximum Date per Dimension

jw22 — Mon, 19 Dec 2022 16:21:41 GMT

Hello Qlik Community,

is there a way to load only the maximum (latest) date per dimension?

So, I have the following Table (example) with different Production lines, the Article number, the Status and the Date of the Status. I only want to load the maximum Date per production line:

So in the example only the green marked Data:

Thanks!

Regards,

Johannes

Re: Load maximum Date per Dimension

BrunPierre — Mon, 19 Dec 2022 21:53:40 GMT

For the date column, use this expression.

Aggr(FirstSortedValue(Date(Date),-Date),[Production Line])

Re: Load maximum Date per Dimension

vinieme12 — Tue, 20 Dec 2022 04:16:38 GMT

As below

Main:

load

ProductionLine,ArticleNumber,Status,Date

From SomeSource;

Inner Join(Main)

Load ProductionLine,Max(Date) as Date

Resident Main

Group by ProductionLine;

Re: Load maximum Date per Dimension

jw22 — Thu, 12 Jan 2023 14:57:54 GMT

Hello,

is it also possible to only do it in the chart diagram, not in the script?

Thanks!

Re: Load maximum Date per Dimension

SingSing16 — Thu, 12 Jan 2023 15:16:00 GMT

I have very similar issue, I am interested too how to do this on diagram (by measure/dimession)

Re: Load maximum Date per Dimension

vinieme12 — Thu, 12 Jan 2023 15:24:54 GMT

You can restrict data using a calculated dimension

=Aggr(If(Datefield=max(Datefield),Datefield), ProductionLine)

Uncheck show null values for this dimension

by adding the same condition to the measures instead; as below

=Sum(Aggr(If(Datefield=max(Datefield),SomeMeasureField), ProductionLine) )