topic Re: Percentile related query in QlikView

Percentile related query

Mon, 12 Jan 2015 05:38:12 GMT

Hi All,

I have straight table which show members wise sum of Turnover.

i want to create a lable/ calulated variable which show me what is the 90 percentile of turnover value.

Member Name	SUM of Turnover	Cumm. Sum of turnover	%TILE
ABC	10	10	5%
XYZ	20	30	14%
EDF	10	40	18%
NOP	30	70	32%
JDF	40	110	50%
UTY	30	140	64%
ORE	20	160	73%
YOI	40	200	91%
ERT	20	220	100%

In the above table 200 is the 90 percentile of the turnover. so this 200 should be store in a varaible.

Kindly let me know how can we do this.

Thanks & Regards,

JKV

Re: Percentile related query

Anonymous — Mon, 12 Jan 2015 06:05:40 GMT

attach your sample qvw . So that you can get correct solution.

Re: Percentile related query

jonathandienst — Mon, 12 Jan 2015 07:47:03 GMT

I would need a sample from you to work out a variable, but you can do this without a variable using Dimension Limits. Select the "Show only values that accumulate to" option and enter 90%.

HTH

Jonathan

Re: Percentile related query

Mon, 12 Jan 2015 08:30:00 GMT

I want to store the percentile result into a variable because i want to use that varaible to create a reference line into a scatter chart.

if i am using default percentile of reference line in scatter chart then it is calculating on basis of no. of Member not on the turnover.

This is why i want to know the the turnover value on 90 %tile position when i create memberwise turnover and also i have to ensure that it will be sorted on turnover desencing order only.

If i get time i will share you the sample data because i have to create it. i can not share the live data.

Thanks all for you help.

JKV