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

    Multiple columns to form a dimension in a column chart

      Hi,

       

      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:

       

      IDStatusABC
      1OpenImpactedImpacted
      2OpenImpacted
      3OpenImpactedImpacted
      4ClosedImpacted

       

      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?