Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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.