title: Qlikview Exclude a value from a list selection box
body: <p>I want to exclude a value from a list selection box.</p>
  
  <p>The field is called <code>Status</code> and there are 4 values <code>All</code>, <code>Yes</code>, <code>No</code> &amp; <code>Deleted</code>.</p>
  
  <p>I want to NOT show <code>All</code></p>
  
  <p>I tried this but it just renames it to <code>0</code></p>
  
  <pre><code>=IF(STATUS &lt;&gt; 'All', STATUS,0)
  </code></pre>