Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

Fractile on list of values

I create a sorted list of values:

=Concat( [WL-WA], ',',[WL-WA])

which results in:

concat sorted.png

and I want the Fractile 0.05 and 0.95 calculated from this list.

Combining Fractile around the concat is not possible because of Nested Aggregations,

I tried to store the Concat in a variable like this: =Fractile('$(vConcatWLWA)', 0.05)

but that also doesn't give a result.

GUI calculation is mandatory because the dependency on front end selections.

1 Solution

Accepted Solutions
Michiel_QV_Fan
Specialist
Specialist
Author

6 Replies
tresesco
MVP
MVP

What do you expect to see for Fractile('$(vConcatWLWA)', 0.05) ?

Michiel_QV_Fan
Specialist
Specialist
Author

-1, which is the 5% value from the start of the list (31,45 th value = 32nd value)

and

1 which is the 95% value from the start of the list (597,55 = 598th value)

ogautier62
Specialist II
Specialist II

Hi

use function mid :

fractile 0.05 = position 0.05 * length of your string

then mid(position,1)

but why using a string and not rows/table ?

regards

Michiel_QV_Fan
Specialist
Specialist
Author

Using a string because only the end result (0,95 - 0.05 values are requested as result) in this example: 2

tresesco
MVP
MVP

If you just need to get two fractiles in the textbox, I guess yoiu could try a simpler expression like:

=Fractile([WL-WA], 0.5) & ',' & Fractile([WL-WA], 0.95)

Michiel_QV_Fan
Specialist
Specialist
Author

I found the solution here:

Get n-th value in GetFieldSelections