title: Qlikview set analysis in chart expression based on dimension
body: <p>I have a chart showing Issued Qty for all transactions from 'From Location' to 'To Location' as follows.</p>
  
  <p><a href="https://i.stack.imgur.com/yUodC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yUodC.jpg" alt="enter image description here"></a></p>
  
  <p>Now I want to show one more column. In it I want to show transaction qty from 'To Location' to 'From Location'. 
  To elaborate, the first row shows Qty issed from Pharmacy to 3rd Flr - NEW AC WARD. So now in the next coloumn, I wish to shwo 
  the qtys issued from 3rd Flr - NEW AC WARD to pharmacy.</p>
  
  <p>Some trick using set analysis would do, but I am not well versed with Set analysis. Please help.</p>
  
  <p>I tried something like this. But this is not working. :(</p>
  
  <pre><code>=Sum ({$&lt;[From_Location_Name] = {[To_Location_Name]}, [To_Location_Name] = {[From_Location_Name]}&gt;}[MatlMoveIssuedQty])
  </code></pre>
  
  <p>I also tried the following, but did not work</p>
  
  <pre><code>=Sum ({$&lt;[From_Location_Name] = p(To_Location_Name)&gt;}[MatlMoveIssuedQty])
  </code></pre>