Text box can change current selection

[#1]

Hi everybody !

Juste a question with the text box

Is it possible to use the text box to do a selection into a list box ?

Check the example to see what I want to do

Thanks a lot for reading this post

[swuehl]

You could use an expression as field in your list box, maybe like:

=if(YearMonth >= date(date#(DateBegin,'MM/YYYY'),'YYYY/MM') and YearMonth <= date(date#(DateEnd,'MM/YYYY'),'YYYY/MM'),YearMonth)

You could probably also use a set expression instead of the if().

Hope this helps,

Stefan

[#3]

Hi,

  You are trying to show the dates in the list box of the selected duration. You can use the calender for selecting the dates and write the expression in the list box. Attached the qvw for your reference.

[#4]

Great! with the calendar is really what i need

Thank you for your two answers !!

[#5]

well in fact, it's not exactly what i want

It's just refrest my list box with the new values but it doesn't select the value

The list box in yours examples doesn't select values in the calendar

What i need with theses box :

I select the started date

I select the end date

And in the Current selections, table calendar is selected month between the two dates.

Is it possible with a trigger ?

[swuehl]

Sure,

add a trigger in document properties - Triggers on the Variables.

See attached.

Stefan

edit: wrong trigger used, hang on

[swuehl · Accepted solution]

This should be correct.

[Miguel_Angel_Baeyens]

Hi,

If you are going to used that with charts and expressions, I recommend to take a look at this application I uplodaded for that purpose, linking dates to a master calendar, and with no need of actually select dates from a listbox, since selections in inputboxes (variables) will affect charts.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#9]

Thank you all for your help!