Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Done that myself
Pfa
See attached qvw.
Put that expression here ,it will helpful for others
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)'&')',))))))))))))
could please tell me the logic behind the qvw
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].