Multiple Value-Selection for Listbox B by triggering Listbox A

[#1]

Hi

I try to select multiple Values of a Listbox B (Date2) by using a Trigger at Listbox A (Date1). I want to select a Date at Listbox A and this will activate a Trigger that select all Dates of Listbox B which are greater than the selected one in Listbox A.

I am using a Field Trigger for the Field "Date1" which will be activate by selection.

For a single Value-Selection following code for the search condition of the Trigger works: (Properties -> Dokument Properties -> Triggers)

='=sum({<Date2 = Date1>}1)'

For multiple Value-Selection i tried this:

='=sum({<Date2={">=Date1"}>}1)'

But its not working

I hope somebody can help me.

thanks a lot.

[Miguel_Angel_Baeyens · Accepted solution]

Hi Mathias,

Try the following instead as condition in field Date2:

='>=' & GetFieldSelections(Date1) 

Hope that helps.

Miguel

[#3]

Thanks a lot! It works fine

[#4]

Hello Sir,

I'm creating a Historical Sales Trend using set analysis to select dates, until i had two historical dates it was ok, one bar was for the max date & the other for the Remaining one date. But now i've three snapshots.

The user wants to select 5 Snapshot dates in future. The probelm is if i use only list box for the date then the second ba wll show sum of all the remaining 4 dates.

i've also tried generating the 5 dates as:

SnapshotCalendarTemp1:
load Distinct
([Snapshot Date]) as [Snapshot Date1] resident Sales;

SnapshotCalendarTemp2:
load Distinct
([Snapshot Date]) as [Snapshot Date2]  resident Sales;

SnapshotCalendarTemp3:
load Distinct
([Snapshot Date]) as [Snapshot Date3] resident Sales;

SnapshotCalendarTemp4:
load Distinct
([Snapshot Date]) as [Snapshot Date4]  resident Sales;

SnapshotCalendarTemp5:
load Distinct
([Snapshot Date]) as [Snapshot Date5]  resident Sales;

to create 5 separate list boxes & then using the expressions to create the list boxes depending on the selection in the previuos list box, hiding/showing them successively.

But its not working properly

PLz help

Regards