Alternate States in Set Analysis

[malmsteen1977]

Hi Community,

is it possible to reference on 2 different Alternate States inside one Set Analysis?

I defined 2 Alternate States (Lagerort, Datum) which represents StorageArea and Date

And the following Expression:

FirstSortedValue({$< MainDate = {"$(='<=' & Date(Max(MainDate)))"}, %ML_Ort_KEY=Lagerort::%ML_Ort_KEY >}Timestamp_Neu,-Timestamp_Neu)

The bolded Expression works perfectly for the PrimaryKey %ML_Ort_KEY "Lagerort (StorageArea)"  and a Listbox on the surface.

My question: Can I include the second Alternate State for "Datum" in the following dynamic part:

MainDate = {"$(='<=' & Date(Max(MainDate)))"}

Greetings

[juraj_misina]

Hello Hannes,

I'm pretty sure I've done something similar, so it should be possible.

Juraj

[malmsteen1977]

Hello Juraj,

sounds good. Do you have a solution?

Best

Hannes

[swuehl · Accepted solution]

Maybe

MainDate = {"$(='<=' & Date(Max({Datum} MainDate)))"}

[malmsteen1977]

Bingo Stefan 🙂

I have set the wrong reference with the following brackets: [] instead of {}

Thanks !!!!!