Here is the issue. There are model years, say 2009 and 2010. I also have months after the start of production call SOP Months. Say for model year 2009, SOP Months = 0,1,2,3,4,5,6,7,8,9,10,11,12. For model year 2010, SOP Months = 0,1,2,3,4,5,6. What I want to display in the SOP Months list box is the union of the SOP Months across model years. In this case, if both model years 2009 and 2010 are selected, the SOP Month list box should show 0,1,2,3,4,5,6 (and not 0,1...11,12). Any idea how to accomplish this in QV? It goes against the 'grain' of QV. Any help would be greatly appreciated. Thanks
I failed to mention I am unfortunately using QV 8.01; I was not able to open the attached project. There are many SOP Months rows per Year (if I understand what you are saying). Example data is below. In this case ,I reduced the data to: 2009 = 0,1,2,3,4; 2010 = 0,1,2; union = 0,1,2. Or more so, the Month list box should show only 0,1,2 when years 2009 and 2010 are selected.
Yes it does; reference the General Tab->Field property (one of the top most selections 'Expression') of the List Box Properties dialog. I did try the Aggr() expression you had sent, but no values were displayed. I believe this was due to multiple rows per model year.
