How can I group the results of a measure into categories?
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?
Re: How can I group the results of a measure into categories?
thanks for the solution. As a follow up, do you happen to know if the fractile function can be dynamic? Meaning I am able to plot the fractile based on the TOTAL records now, however, if I filter the results based on a network, the dimension on the x-axis remains. Is there a way to make it dynamic and to replot the fractile (x-axis) based on this selected filter?