How to remove data from a List box based on Data selected in other listbox ?

[shekhar_analyti]

Hi All ,

I have Two list boxes with name as folows
1)  Select Date

2)  Result Date

Both uses same field from table .

My requirement is that when user selects a value in Select Date List box , then that particular value should be removed from Result Date list box but when user deselects a value then from Select Date List box then that value should re appear or retained in Result Date List Box .

Thanks & Regards

Shekar 

[awhitfield]

Why do you want to do this? What are you actually trying to achieve?

Andy

[shekhar_analyti]

I just wanted to know , if this can be done ? Answer to this will lead me to a much needed solution ...

[awhitfield]

Sounds like you actually want to display all values except those selected in a chart perhaps, rather than in another list box??

May be like this?

In which case you could use set analysis to display values whose dates are exclude by your selection, e.g.

Sum({<Date = e(Date)>}Sales)

as the expression in the chart show??

Andy

[Peter_Cammaert · Accepted solution]

It can be made to work if you select at least one value in [Select Date]. Otherwise the Result Date list will be empty because clicking the Clear button will mean "everything selected".