topic Re: Fractile function returning invalid dimension in App Development https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119523#M8303 <HTML><HEAD></HEAD><BODY><P>What are you expecting as your answer maybe you are using the wrong function.</P></BODY></HTML> Fri, 19 Oct 2018 05:48:31 GMT sibusiso90 2018-10-19T05:48:31Z Fractile function returning invalid dimension https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119522#M8302 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table as below</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Item</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Price</TH></TR><TR><TD style="padding: 2px;">Apple from North</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">Apple from South</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">Apple from East</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">Apple from West</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P></P><P>I have uploaded this data into my app. I wanted to show in my app the 75 percentile. I found a function Field=Factile(item,0.75) but when I apply this, the table will show "Invalid dimension". </P><P></P><P>Documentation at <A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/fractile.htm?_ga=2.54512490.352471403.1539489312-1714113449.1537148227" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinCharts/fractile.htm?_ga=2.54512490.352471403.1539489312-1714113449.1537148227">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/ChartFunctions/StatisticalAggregationFunctionsinChar…</A> seems very direct but I not sure if I did it correctly. Please help?</P></BODY></HTML> Fri, 19 Oct 2018 02:58:41 GMT https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119522#M8302 wuming79 2018-10-19T02:58:41Z Re: Fractile function returning invalid dimension https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119523#M8303 <HTML><HEAD></HEAD><BODY><P>What are you expecting as your answer maybe you are using the wrong function.</P></BODY></HTML> Fri, 19 Oct 2018 05:48:31 GMT https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119523#M8303 sibusiso90 2018-10-19T05:48:31Z Re: Fractile function returning invalid dimension https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119524#M8304 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>Sorry, I figured I need to add data as dimension and change from there. </P></BODY></HTML> Fri, 19 Oct 2018 05:49:53 GMT https://community.qlik.com/t5/App-Development/Fractile-function-returning-invalid-dimension/m-p/119524#M8304 wuming79 2018-10-19T05:49:53Z