Creating Input Box with values from input field

[manpri7078]

Dear All,

I want to create an input box with drop down values picking from a field list. The creation of list box is no problem but I want to create an input box for the same. The reason being I don't want to select that field because then whole Qlikview document will show objects with reference to that field.

I want to use that input box selection as a variable in some expressions independent of other objects anywhere else in the document and be restricted to that expression only.

The field is of month name and I want to select the desired month name from drop down values in an input box. The predefined values should show all possible values from that field or show only those values which are within n months back from a selected month.

Regards,

Manish Prasad

[manpri7078]

Dear Sunny,

Thanks for the guidance. I had missed completely what changes was required.

Regards

Manish Prasad

[sunny_talwar]

This change was more important than the other one. Because second time we use MonthYear is to actually order the Concat function... So this should also work for you

=Concat({1}DISTINCT Date([Mon-Y], 'MMM-YY'), ',', [Mon-Y])