topic Re: Select All previous Months on ListBox in QlikView

Select All previous Months on ListBox

techvarun — Fri, 07 Nov 2014 11:31:23 GMT

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

Re: Select All previous Months on ListBox

techvarun — Fri, 07 Nov 2014 12:04:29 GMT

Done that myself

Pfa

Re: Select All previous Months on ListBox

Gysbert_Wassenaar — Fri, 07 Nov 2014 12:08:44 GMT

See attached qvw.

Re: Select All previous Months on ListBox

Fri, 07 Nov 2014 12:11:10 GMT

Put that expression here ,it will helpful for others

Re: Select All previous Months on ListBox

Fri, 07 Nov 2014 17:46:53 GMT

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)'&')',))))))))))))

Re: Select All previous Months on ListBox

Fri, 07 Nov 2014 17:47:41 GMT

Hi Gysbert Wassenaar

could please tell me the logic behind the qvw

Re: Select All previous Months on ListBox

Gysbert_Wassenaar — Sat, 08 Nov 2014 17:29:59 GMT

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].