Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to count the number of records supporting a FRACTILE

Hi,

Another newbie question for the experts...

I am using the FRACTILE function to determine the 90% fill rate on a volume of order line items.

=FRACTILE(ORDER_TAT,0.9)

which returns me a value of 3.0

What I want to do now is see how many orders make up this value.

I thought something like:

=COUNT(FRACTILE(ORDER_TAT,0.9),order_no)

but this does not work.... I know what the values should be based on examination of the raw data in Excel.  The number of records will change from month to month, so I want to calculate my fractile value (which is in days) and see the number of records supporting that.

Anyone have an idea on what I could do?

thanks,

1 Solution

Accepted Solutions
simenkg
Specialist
Specialist

How about:


COUNT(if(ORDER_TAT <= FRACTILE(Total ORDER_TAT,0.9),order_no))

View solution in original post

7 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

=COUNT(if ORDER_TAT <= FRACTILE(ORDER_TAT,0.9),order_no)



-Rob

Not applicable
Author

Error in that expression... is there some syntax missing around if?

simenkg
Specialist
Specialist

=COUNT(if(ORDER_TAT <= FRACTILE(ORDER_TAT,0.9),order_no))


Some missing parenthesis.

Not applicable
Author

This looks perfect to me, but I still get "error in expression"

I tried taking out the spaces around the <= as well with no luck.

very frustrating.....

simenkg
Specialist
Specialist

How about:


COUNT(if(ORDER_TAT <= FRACTILE(Total ORDER_TAT,0.9),order_no))

Not applicable
Author

that works perfectly.

You sir are a genius.

simenkg
Specialist
Specialist

Glad I could help