0 Replies Latest reply: Mar 8, 2017 8:25 AM by Abhishek gupta RSS

    Create a Histogram for percentages range

    Abhishek gupta

      Hi All,

       

      I am trying to create a histogram in Qlik sense desktop for which the data looks like:

       

      Test name (Unique value)Performance
      abc-20%
      def5%
      qew11%
      klm22%
      pll3%
      tkl34%

       

      • Test name: Is unique for each test
      • Performance: if the results of the test

      Requirement: I would like a histogram that classifies performance in Bins (-20% to -15% (bin1), -14% to -9% (bin2)............. 30% to 35% (bin x)) . and want a count of test name against it,

      So,

      • Requirement 1: Bins of equal range (5% points)
      • Requirement 2: Bins of Custom range (say bin 1= -20% to 0, bin 2: 0 to 5%, bin 3= 6%-10% and bin 4= >11%)