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: 
skellington
Contributor II
Contributor II

Comparing each # with the 1st Quartile # of that same column

Hello there folks .. here's another question .. 

I have a COLUMN_A with values that are COUNT (DISTINCT Field#1)

in COLUMN_B .. I wanna compare each value in COLUMN_B with the lowest Quartile figure of the stack of numbers in COLUMN_A

I assume the first thing I need to do is to GET that lowest Quartile figure .. but for the life of me I can't get the "fractile" function to work ..

.. my latest try is .. =FRACTILE(Aggr(Count(Distinct Field#1)),0.25) which is most likely wrong as it is not working for me .. Thoughts?

Thx

2 Replies
sunny_talwar

What is your chart dimension here?

skellington
Contributor II
Contributor II
Author

Ah .. no worries mate.. got that resolved today.  Sorry for not giving enough info in my question.  I really appreciate your quick response.