4 Replies Latest reply: Dec 2, 2016 1:38 PM by Sebastian Spur RSS

    Creating a Histogram in Sense... help please!

    Sebastian Spur

      Hi all!

       

      I'm new to Qlik and to programming, so I'm still getting my feet wet here. I am trying to create a histogram based on 2 fields in my data - Revenue & Target. What I'm trying to create is a histogram for the frequencies of the ratio Revenue/Target=Attainment. This is how my table is organized

       

      IDQuarterRevenueTarget
      123451100120
      12345215089
      345671200125
      345672130345
      3456735001250

       

      I need to set the bins at intervals of 5% (or 10%) and know the count of the attainment (Revenue/Target) for that range. I assume that filtering out globally an ID, a Quarter or another field will modify the histogram accordingly.

       

      I've tried looking at other postings but I'm not being able to translate them to my reality. Any assistance will be very welcome.

       

      Thanks