Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Multiple Value-Selection for Listbox B by triggering Listbox A

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.

1 Solution

Accepted Solutions

Re: Multiple Value-Selection for Listbox B by triggering Listbox A

Hi Mathias,

Try the following instead as condition in field Date2:

='>=' & GetFieldSelections(Date1)

Hope that helps.

Miguel

3 Replies

Re: Multiple Value-Selection for Listbox B by triggering Listbox A

Hi Mathias,

Try the following instead as condition in field Date2:

='>=' & GetFieldSelections(Date1)

Hope that helps.

Miguel

Not applicable

Multiple Value-Selection for Listbox B by triggering Listbox A

Thanks a lot! It works fine

Not applicable

Multiple Value-Selection for Listbox B by triggering Listbox A

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