2 Replies Latest reply: Oct 31, 2017 6:52 AM by Rony Fayyad RSS

    Bar chart with unique fields

    Rony Fayyad

      I am very new to Qlik and need help creating a bar graph with the below fields.

       

      1. Prior year revenue

      2. Year to date revenue

      3. Year to go revenue

      4, Year to date forecast

      5. Year to go forecast

       

      I can do this in Excel very easily but now I am trying to find the right (and most straightforward) way to do this with Qlik Sense.I want to be able to stack fields 2 and 4, and 3 and 5 in the bar graph as well.

       

      I am familiar with creating charts just not sure how to tackle this use case which has five unrelated fields.

       

      Any help is appreciated.

        • Re: Bar chart with unique fields
          Mark Ritter

          So each of these would be measures in your bar chart.

           

          You could display each as separate bar for each Dimension.  Or you can stack them for each Dimension.

           

          You could also set them up as Alternative measures so that the user would pick one at a time.

           

          I don't know of a way to pick which ones stack on each other out of the box.  You could possibly use a button extension and create buttons for each of these measures.  Then the user could pick whatever combination of the 5 that they want to see stacked together.

            • Re: Bar chart with unique fields
              Rony Fayyad

              Thanks Mark.

               

              I have created the five unique fields as measures using expressions to limit the value to the required value. Now when I go to add a dimension, I realised it wouldn't work because they do not share the same dimension. As an example, I expect the X axis to contain the label for each of the unique fields, and the Y-axis to contain the actual numerical value of each measure. See below.

               

              I am trying to create something similar to this bar graph.

              Screen Shot 2017-10-31 at 9.50.27 pm.png