title: QlikView Problems with Listbox
body: <p>I want to have a list box that shows the following:
  <code>YYYY: WeekNumber - Date</code></p>
  
  <p>The <code>Date</code> part is using a Broadcast Calendar (starts on Sundays, so week 1 of 2012 is actually Monday <code>12/26/2011</code>).</p>
  
  <p>This needs to be conditional:</p>
  
  <ul>
  <li><p>If the year selected is the current year, only show through the latest "broadcastMonday" which in this case is Week 9 (<code>2/20/2012</code>). Then go back all the way through the prior year to week 1 of 2011, which is actually <code>12/27/2010</code>.</p></li>
  <li><p>If the year selected is less than the current year, only show all of that year plus all of the prior year.</p></li>
  </ul>
  
  <p>The following expression for the List Box is working just fine for me with respect to displaying the right information, but when I click an item in the list it doesn't select it:</p>
  
  <pre><code>=If([Year]=year(ReloadTime()),if(left(BroadcastPeriod2,4)&gt;=[Prior Year]
  and BroadcastWeekStart2&lt;ReloadTime(),(left(BroadcastPeriod2,4) &amp; ' : ' &amp; 
  BroadCastWeek2 &amp; '-' &amp; date(BroadcastWeekStart2)),),if(left(BroadcastPeriod2,4)&gt;=
  [Prior Year] and left(BroadcastPeriod2,4)&lt;=([Year]),left(BroadcastPeriod2,4) &amp; ' : '
  &amp; BroadCastWeek2 &amp; '-' &amp; date(BroadcastWeekStart2),)) 
  </code></pre>