topic Re: Text box can change current selection in QlikView

Text box can change current selection

Tue, 18 Oct 2011 14:34:26 GMT

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

Re: Text box can change current selection

swuehl — Tue, 18 Oct 2011 15:36:20 GMT

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

Re: Text box can change current selection

Tue, 18 Oct 2011 15:40:25 GMT

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.

Text box can change current selection

Tue, 18 Oct 2011 15:54:45 GMT

Great! with the calendar is really what i need

Thank you for your two answers !!

Text box can change current selection

Tue, 18 Oct 2011 16:12:44 GMT

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 ?

Re: Text box can change current selection

swuehl — Tue, 18 Oct 2011 16:17:39 GMT

Sure,

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

See attached.

Stefan

edit: wrong trigger used, hang on

Re: Text box can change current selection

swuehl — Tue, 18 Oct 2011 16:55:59 GMT

This should be correct.

Re: Text box can change current selection

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 17:23:46 GMT

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

Re: Text box can change current selection

Wed, 19 Oct 2011 16:33:48 GMT

Thank you all for your help!