Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Alternate States in Set Analysis

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Alternate States in Set Analysis

Maybe

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

4 Replies
Luminary
Luminary

Re: Alternate States in Set Analysis

Hello Hannes,

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

Juraj

Partner
Partner

Re: Alternate States in Set Analysis

Hello Juraj,

sounds good. Do you have a solution?

Best

Hannes

MVP
MVP

Re: Alternate States in Set Analysis

Maybe

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

Partner
Partner

Re: Alternate States in Set Analysis

Bingo Stefan 🙂

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

Thanks !!!!!