topic How to do Quartiles in the script in QlikView https://community.qlik.com/t5/QlikView/How-to-do-Quartiles-in-the-script/m-p/514503#M692343 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I´ve this app that has the following columns USERID,monthtx and amounttx which has the amount of money spend on any given month.</P><P></P><P>so my goal is categorize or organize with quartils the user upon the amount they spend throught out six month period which is a data range that i have. </P><P></P><P></P><P>How do i do that.?</P><P></P><P></P><P>the total rows is aprox 12 millons..</P><P></P><P>any help will be appreciated.</P><P></P><P>JuanD</P></BODY></HTML> Wed, 21 Aug 2013 18:40:14 GMT 2013-08-21T18:40:14Z How to do Quartiles in the script https://community.qlik.com/t5/QlikView/How-to-do-Quartiles-in-the-script/m-p/514503#M692343 <HTML><HEAD></HEAD><BODY><P>Good day,</P><P></P><P>I´ve this app that has the following columns USERID,monthtx and amounttx which has the amount of money spend on any given month.</P><P></P><P>so my goal is categorize or organize with quartils the user upon the amount they spend throught out six month period which is a data range that i have. </P><P></P><P></P><P>How do i do that.?</P><P></P><P></P><P>the total rows is aprox 12 millons..</P><P></P><P>any help will be appreciated.</P><P></P><P>JuanD</P></BODY></HTML> Wed, 21 Aug 2013 18:40:14 GMT https://community.qlik.com/t5/QlikView/How-to-do-Quartiles-in-the-script/m-p/514503#M692343 2013-08-21T18:40:14Z Re: How to do Quartiles in the script https://community.qlik.com/t5/QlikView/How-to-do-Quartiles-in-the-script/m-p/514504#M692344 <HTML><HEAD></HEAD><BODY><P>You can use the fractile function to calculate the quartile values: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">fractile(Amount,.25). </SPAN></P></BODY></HTML> Wed, 21 Aug 2013 18:52:37 GMT https://community.qlik.com/t5/QlikView/How-to-do-Quartiles-in-the-script/m-p/514504#M692344 Gysbert_Wassenaar 2013-08-21T18:52:37Z