4 Replies Latest reply: Aug 4, 2014 3:28 AM by Duncan Lee RSS

    Multiple columns to form a dimension in a column chart



      I'm completely new to Qlik Sense, and having trouble displaying data in a column chart. I have a feeling that my data source (Excel spreadsheet) is not structured in an appropriate way. Otherwise, maybe I just don't know how to set it up.


      My data looks like:




      I want to create a column chart which shows A, B, C along the x-asis and the Count of 'Open' IDs that belong to the A, B, C.


      So it should appear like:

      A = 2

      B = 2

      C = 1


      Is there a way to do this using the data I have?