
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Thank you!

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, you can. See this blog post for an example: http://www.qlikfix.com/2010/10/08/decile-analysis/
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
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?
Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I don't see any reason why a selection wouldn't affect the x-axis unless you explicitly make the calculated dimension ignore those selections.
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the clarifications. Was just confused by the aggregation scope -> Defining the aggregation scope ‒ Qlik Sense
