title: Stacked Multi Bar Graph in Qlikview
body: <p>Background Knowledge on Application:</p>
  
  <ol>
  <li>In Simulation many users can be involved but a few (typically 2 to 3) will do actually the Simulation.</li>
  <li>A Simulation has Phases, A Phase has Actions and these can be performed by users in the process of Simulation.</li>
  <li>A set of Users will do a Simulation and another set of Users will observe that process.</li>
  <li>Once the Simulation process is done, the users who are observing the simulation will evaluate the users who did actually. And at the same time the faculty will also evaluate the users (who did the simulation)</li>
  </ol>
  
  <p>I have implemented a dashboard/graph to represent the complete above scenario, by directly showing graph based on simulation id and user in the beginning. If we select any particular simulation then the graph changes o next level i.e based on users, who did that simulation actually (Here the dimension is user name). Then if we select any user then it will dig down to next level i.e based on the phases (here the dimension is phase), again if we select the phase then it will change, based on the actions (here dimension is the action).</p>
  
  <p>This part id done and attached the screenshot and .qvw file as well.</p>
  
  <p>Now the main task here is, I need to compare student given marks with faculty given marks (both are in different tables, i.e studentscore &amp; facultyscore), in the same graph using stacked multi bar graph at user level, phase level, action level.</p>
  
  <p>Attached the screenshot for reference (please see in the Reference sheet).</p>
  
  <p>May be some of the dimensions or expression are wrong, or I am not sure actually.</p>
  
  <p>I am able to do with only one level, but not in these levels (level by level, like, based on users, based on phases, and based on actions)</p>
  
  <p>I really tried in many ways, but it is not working as expected.</p>
  
  <p>You can download the attachments here
  <a href="https://slack-files.com/T02FXUAB9-F308KT8PQ-c53db69bbb" rel="nofollow noreferrer">https://slack-files.com/T02FXUAB9-F308KT8PQ-c53db69bbb</a></p>
  
  <p><a href="https://slack-files.com/T02FXUAB9-F2YSTAW72-bba2433d6f" rel="nofollow noreferrer">https://slack-files.com/T02FXUAB9-F2YSTAW72-bba2433d6f</a></p>