Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

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!

4 Replies

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

Yes, you can. See this blog post for an example: http://www.qlikfix.com/2010/10/08/decile-analysis/

Not applicable

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

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.

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

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.

Not applicable

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

Thank you for the clarifications. Was just confused by the aggregation scope -> Defining the aggregation scope ‒ Qlik Sense