title: Limit dimension values displayed in QlikView Pivot Table Chart
body: <p>I have a pivot table chart in QlikView that has a dimension and an expression. The dimension is a column with 5 possible values: 'a','b','c','d','e'.</p>
  
  <p>Is there a way to restrict the values to 'a','b' and 'c' only? </p>
  
  <p>I would prefer to enforce this from the chart properties with a condition, instead of choosing the values from a listbox if possible.</p>
  
  <p>Thank you very much, I_saw_drones! There is an problem I have though. I have different expressions defined depending on the category, like this: </p>
  
  <pre><code>IF( ([Category]) = 'A' , COUNT( {&lt;[field1] = {'x','y'} &gt;} [field2]), IF ([Category]) = 'B' , SUM( {&lt;[field3] = {'z'} &gt;} [field4]), IF (Category='C', ..., 0))) 
  </code></pre>
  
  <p>In this case, where would I add <code>$&lt;Category={'A','B','C'}</code> ? My expression so far doesn't help because although I tell QV to use a different formula/calculation for each category, the category overall (all 5 values) represents the dimension.</p>