4 Replies Latest reply: Aug 1, 2018 5:47 AM by Jerry Ile RSS

    Buckets

    Jerry Ile

      HI,

       

      I need to create some price buckets in Qlik Sense

       

      taking this format of example data    

      SKURRPSum([Sold GBP])Sum([Sold Qty])
      GAKJ06A01330£3,510.00233
      ML3498A01830£1,984.17233
      YD00080801840£9,300.00233
      YK00001818150£10,150.00232
      YT00071202725£4,384.00231
      YT00083812530£4,186.38231

       

      Would like to bucket into groups of MD percentages

      70%+

      50-69% MD

      30-49% MD

      10-29% MD

      Full Price

       

      I tried some nested ifs and read about the Class function but not sure how to use as I'm comparing (Sold GBP / Sold Qty) with the RRP