4 Replies Latest reply: Jul 13, 2016 10:17 PM by Wei Chong Tan RSS

    How can I group the results of a measure into categories?

    Wei Chong Tan

      Assuming I have data on the speed of different network from different locations, meaning my columns are: speed, network and location.

       

      I would like to categorize the data set based on the percentile the speed falls in and plot a visualisation. Meaning, I want to have 10 categories, each corresponding to the 0-10 percentile, 11-20, 21-30, 31-40 ... 91-100 percentile, and these 10 categories will serve as the x-axis. and on the y-axis will be the count of data that falls within these categories or it could be the average speed that these categories is in, how do I do that with qlik?

       

      Thank you!