Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
Showing results for 
Search instead for 
Did you mean: 
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?


2 Replies

What is your chart dimension here?

Contributor II
Contributor II

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