topic Alternate States in Set Analysis in QlikView

Alternate States in Set Analysis

malmsteen1977 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 27 Sep 2018 11:07:46 GMT

Hello Hannes,

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

Juraj

malmsteen1977 — Thu, 27 Sep 2018 11:10:59 GMT

Hello Juraj,

sounds good. Do you have a solution?

Best

Hannes

swuehl — Thu, 27 Sep 2018 11:14:32 GMT

Maybe

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

malmsteen1977 — Thu, 27 Sep 2018 11:23:22 GMT

Bingo Stefan 🙂

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

Thanks !!!!!