topic Re: Calculating value after fractile in QlikView

Calculating value after fractile

Anonymous — Wed, 16 Mar 2016 10:11:15 GMT

Here is my issue: I need to calculate value after fractile value.

Foe example for Category1 fractile value is 4.32 and value after it is 5, that is the one I would like to show to the user

This function does not work

=Min(If Value>Fractile(Value,0.83),Value)

Any suggestions?

Data:

LOAD * INLINE [

Category, Value

Category1, 1

Category1, 2

Category1, 3

Category1, 4

Category1, 5

Category2, 1

Category2, 3

Category2, 4

Category2, 11

];

Chanty4u — Wed, 16 Mar 2016 12:00:32 GMT

Fractile( aggr(avg(sales), somefield),0.83)

Chanty4u — Wed, 16 Mar 2016 12:03:41 GMT

=fractile(If([value]>( [value]),0.83)

sunny_talwar — Wed, 16 Mar 2016 12:30:14 GMT

May be this:

=Min(If(Value>Fractile(TOTAL Value,0.83),Value))

Anonymous — Wed, 16 Mar 2016 12:47:09 GMT

No, it does not work

=Min(If(Value>Fractile(TOTAL Value,0.83),Value))

this calculates it for all records

Fractile(TOTAL Value,0.83)

sunny_talwar — Wed, 16 Mar 2016 20:20:13 GMT

I am not sure what else you are looking for? Can you elaborate on the result you are looking for?

swuehl — Wed, 16 Mar 2016 20:33:17 GMT

Try

=Min(Aggr(If (Value>Fractile(TOTAL<Category> Value,0.83),Value),Category,Value))