Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
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.