topic Deciles Calculation On script in QlikView https://community.qlik.com/t5/QlikView/Deciles-Calculation-On-script/m-p/630172#M231282 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>For calculating deciles, I am using the below expression which is working file on charts with all dimensions</P><P><STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.1</SPAN>), <SPAN style="color: #ff6600;">10</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.2</SPAN>), <SPAN style="color: #ff6600;">9</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.3</SPAN>), <SPAN style="color: #ff6600;">8</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.4</SPAN>), <SPAN style="color: #ff6600;">7</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.5</SPAN>), <SPAN style="color: #ff6600;">6</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.6</SPAN>), <SPAN style="color: #ff6600;">5</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.7</SPAN>), <SPAN style="color: #ff6600;">4</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.8</SPAN>), <SPAN style="color: #ff6600;">3</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.9</SPAN>), <SPAN style="color: #ff6600;">2</SPAN>, <SPAN style="color: #ff6600;">1</SPAN>)))))))))</P><P></P><P>Please let me know how the same can be achieved from script?</P></BODY></HTML> Wed, 28 May 2014 04:13:44 GMT Kushal_Chawda 2014-05-28T04:13:44Z Deciles Calculation On script https://community.qlik.com/t5/QlikView/Deciles-Calculation-On-script/m-p/630172#M231282 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>For calculating deciles, I am using the below expression which is working file on charts with all dimensions</P><P><STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.1</SPAN>), <SPAN style="color: #ff6600;">10</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.2</SPAN>), <SPAN style="color: #ff6600;">9</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.3</SPAN>), <SPAN style="color: #ff6600;">8</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.4</SPAN>), <SPAN style="color: #ff6600;">7</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.5</SPAN>), <SPAN style="color: #ff6600;">6</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.6</SPAN>), <SPAN style="color: #ff6600;">5</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.7</SPAN>), <SPAN style="color: #ff6600;">4</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.8</SPAN>), <SPAN style="color: #ff6600;">3</SPAN>,</P><P> <STRONG style="color: #800080;">if</STRONG>(<STRONG style="color: #339966;">Profit </STRONG>&lt;= <STRONG style="color: #993366;">fractile</STRONG>(<STRONG><SPAN style="color: #0000ff;">TOTAL </SPAN><SPAN style="color: #339966;">Profit</SPAN></STRONG>, <SPAN style="color: #ff6600;">0.9</SPAN>), <SPAN style="color: #ff6600;">2</SPAN>, <SPAN style="color: #ff6600;">1</SPAN>)))))))))</P><P></P><P>Please let me know how the same can be achieved from script?</P></BODY></HTML> Wed, 28 May 2014 04:13:44 GMT https://community.qlik.com/t5/QlikView/Deciles-Calculation-On-script/m-p/630172#M231282 Kushal_Chawda 2014-05-28T04:13:44Z Re: Deciles Calculation On script https://community.qlik.com/t5/QlikView/Deciles-Calculation-On-script/m-p/630173#M231283 <HTML><HEAD></HEAD><BODY><P>Using Group By. Try to share a sample app with inline data and explain expected output.</P></BODY></HTML> Wed, 28 May 2014 04:45:34 GMT https://community.qlik.com/t5/QlikView/Deciles-Calculation-On-script/m-p/630173#M231283 tresB 2014-05-28T04:45:34Z