How to classify data based on percentile

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi:

I have a question regarding classifying companies based on their revenue. . Following is my data

What I want is that,

Based on what I select in Filters (TechName, Region, Country and DataYear) some companies are short listed.
Then I want to rank those companies based on their revenue percentile, as " 3 = High, 2 = Med and 1 = Low", as follows, ,
- If(revenuePercentile > .75, 3, if(revenuePercentile < .25, 1, 2))
Question is how can I calculate the revenuePercentile that's also dynamically updated based on group of companies being filtered.

I am quite new and any detailed solution/help will be highly appreciated. I tried using fractile() function but can't really figure out as how to use it.

stalwar1‌

Re: How to classify data based on percentile

Anonymous — Wed, 29 Aug 2018 03:58:36 GMT

I am adding an expression in the above straight chart as follow,

if(Revenue>=Fractile(Total Revenue, 0.75), 3,

if(Revenue<Fractile(Total Revenue, 0.25), 1, 2))

Does it make sense, , if not then what's the best way to do this?

topic Re: How to classify data based on percentile in QlikView

How to classify data based on percentile

Re: How to classify data based on percentile