Try the following instead as condition in field Date2:
='>=' & GetFieldSelections(Date1)
Hope that helps.
qcomDate1Date2Trigger.qvw 150.5 K
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:
([Snapshot Date]) as [Snapshot Date1] resident Sales;
([Snapshot Date]) as [Snapshot Date2] resident Sales;
([Snapshot Date]) as [Snapshot Date3] resident Sales;
([Snapshot Date]) as [Snapshot Date4] resident Sales;
([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