Select All previous Months on ListBox

[techvarun]

Hi All,,

I am attaching my application with 2 list boxes MonthSelected and Month,

My requirement is if i select month 6 then monthselected list box should be selected with

Jan Feb Mar Apr May Jun

If I select 3 then the month selected should select Jan Feb and Mar

Thanks

Varun

[techvarun]

Done that myself

Pfa

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#4]

Put that expression here ,it will helpful for others

[#5]

techvarun expression

=if(GetFieldSelections([Month Selected])= 'Jan','('&'$(vJan)'&')',

if(GetFieldSelections([Month Selected])= 'Feb','('&'$(vFeb)'&')',

if(GetFieldSelections([Month Selected])= 'Mar','('&'$(vMar)'&')',

if(GetFieldSelections([Month Selected])= 'Apr','('&'$(vApr)'&')',

if(GetFieldSelections([Month Selected])= 'May','('&'$(vMay)'&')',

if(GetFieldSelections([Month Selected])= 'Jun','('&'$(vJun)'&')',

if(GetFieldSelections([Month Selected])= 'Jul','('&'$(vJul)'&')',

if(GetFieldSelections([Month Selected])= 'Aug','('&'$(vAug)'&')',

if(GetFieldSelections([Month Selected])= 'Sep','('&'$(vSep)'&')',

if(GetFieldSelections([Month Selected])= 'Oct','('&'$(vOct)'&')',

if(GetFieldSelections([Month Selected])= 'Nov','('&'$(vNov)'&')',

if(GetFieldSelections([Month Selected])= 'Dec','('&'$(vDec)'&')',))))))))))))

[#6]

Hi Gysbert Wassenaar

could please tell me the logic behind the qvw

[Gysbert_Wassenaar]

The example I posted uses a Select in Field action assigned to the OnSelect field trigger. The action will be executed when a value is selected in the field [Month Selected]. It will select values in the field [Month] that are smaller than or equal to the maximum value selected in the field [Month Selected].