Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Percentile calculation

Hi All,

I need to calculate Salary range percentile for employees. How can this be achieved ?

Please provide me examples on this.

Regards.

2 Replies
Highlighted

Re: Percentile calculation

Fractile( Salary, 0.75 )

will calculate the 75% fractile of the field Salary.

HIC

Highlighted

Re: Percentile calculation

Hi,

Like this..?

SAL:

LOAD *,Num((Sal_Off_Min_Diff/Max_MinDiff)*100,'#,##0.00') as Percentile;

LOAD *,

  [Max Salary]-[Min Salary] as Max_MinDiff,

  [Salary Offered]-[Min Salary] as Sal_Off_Min_Diff

INLINE [

    Min Salary, Max Salary, Salary Offered

    76000, 95000, 80000

    34000, 45000, 43000

    36831, 55500, 40422

    77000, 94000, 78000

];

Result:

Picture1.jpg