Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vvira1316
Specialist II
Specialist II

How to use fractile on subset after fractile is used to divide set in four quartiles

Hi,

I've a scenario where I've a set of data for Sales information. I've found 0.25, 0.5, and 0.75 Fractile  value for it, After that I'm displaying Quartile 4, Quartile 3, Quartile 2, and Quartile 1 based on comparing Sales value to the corresponding Fractile values obtained.

Now I've to find 0.5 Fractile Sales value within each Quartile and Summarize for the user.

Please advise how I should do it.

Here is the sample data set

Sales Total Rank Quartile

$976,086.50 1 Quartile 4

$783,245.41 2 Quartile 4

$753,885.56 3 Quartile 4

$745,304.97 4 Quartile 4

$723,718.25 5 Quartile 4

$722,650.89 6 Quartile 3

$709,379.75 7 Quartile 3

$668,184.24 8 Quartile 3

$648,683.39 9 Quartile 3

$620,118.76 10 Quartile 3

$617,171.31 11 Quartile 2

$608,873.66 12 Quartile 2

$529,959.86 13 Quartile 2

$511,669.81 14 Quartile 2

$492,137.29 15 Quartile 2

$418,783.34 16 Quartile 1

$365,804.68 17 Quartile 1

$349,612.03 18 Quartile 1

$340,318.39 19 Quartile 1

$322,617.31 20 Quartile 1

Thanks,

Vijay

0 Replies