title: How to show sum of different columns using a pie chart in QlikView?
body: <p>My Excel source data looks like this:</p>
  
  <pre><code>State   A   B   C   D   E   F  Total
  ------------------------------------
  India   5   2   1   9   5   5  27
  USA     4   5   6   5   4   2  26
  Germany 1   2   2   5   2   1  13
  </code></pre>
  
  <p>I need the following columns:</p>
  
  <pre><code>Column 1  High = A+B+C+D
  Column 2  Low  = E+F
  </code></pre>
  
  <p>For example, for India the result should be:</p>
  
  <pre><code>High = 17
  Low  = 10
  </code></pre>
  
  <p>If I select India, I need to show the result like this:</p>
  
  <p><img src="https://i.stack.imgur.com/v5fBK.png" alt="enter image description here"></p>
  
  <p>I tried to add a calculated dimension to the chart as below:</p>
  
  <pre><code>State
  High (A+B+C+D)
  Low  (E+F)
  </code></pre>
  
  <p>How can I recreate the above pie chart in QlikView?</p>