topic Re: Comparing each # with the 1st Quartile # of that same column in QlikView https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401829#M819021 <HTML><HEAD></HEAD><BODY><P>Ah .. no worries mate.. got that resolved today.&nbsp; Sorry for not giving enough info in my question.&nbsp; I really appreciate your quick response.</P></BODY></HTML> Wed, 16 Aug 2017 08:54:52 GMT skellington 2017-08-16T08:54:52Z Comparing each # with the 1st Quartile # of that same column https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401827#M819019 <HTML><HEAD></HEAD><BODY><P>Hello there folks .. here's another question ..&nbsp; </P><P></P><P>I have a COLUMN_A with values that are COUNT (DISTINCT Field#1)</P><P></P><P>in COLUMN_B .. I wanna compare each value in COLUMN_B with the lowest Quartile figure of the stack of numbers in COLUMN_A</P><P></P><P>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 ..</P><P></P><P>.. 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?</P><P></P><P>Thx </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401827#M819019 skellington 2020-11-25T16:16:04Z Re: Comparing each # with the 1st Quartile # of that same column https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401828#M819020 <HTML><HEAD></HEAD><BODY><P>What is your chart dimension here?</P></BODY></HTML> Tue, 15 Aug 2017 11:18:53 GMT https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401828#M819020 sunny_talwar 2017-08-15T11:18:53Z Re: Comparing each # with the 1st Quartile # of that same column https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401829#M819021 <HTML><HEAD></HEAD><BODY><P>Ah .. no worries mate.. got that resolved today.&nbsp; Sorry for not giving enough info in my question.&nbsp; I really appreciate your quick response.</P></BODY></HTML> Wed, 16 Aug 2017 08:54:52 GMT https://community.qlik.com/t5/QlikView/Comparing-each-with-the-1st-Quartile-of-that-same-column/m-p/1401829#M819021 skellington 2017-08-16T08:54:52Z