topic Fractile a dynamic variable? in QlikView https://community.qlik.com/t5/QlikView/Fractile-a-dynamic-variable/m-p/1004452#M650397 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to fractile a dynamic variable that ignores all selections.</P><P></P><P>Variable:</P><UL><LI>vMetric = sum(sales)</LI></UL><P></P><P>Aggregate by:</P><UL><LI>Product</LI></UL><P></P><P>Tables:</P><UL><LI>Percentile<UL><LI>This is a table that has 0% to 100% by 10% increments and is used as the</LI></UL></LI></UL><P></P><P>Current expression:</P><P></P><P class="p1">=fractile<SPAN class="s1">({1&lt;</SPAN><SPAN class="s2">Market</SPAN><SPAN class="s1">=</SPAN>P<SPAN class="s1">(</SPAN><SPAN class="s2">Market</SPAN><SPAN class="s1">)&gt;}</SPAN>aggr<SPAN class="s1">(</SPAN>nodistinct<SPAN class="s1"> (</SPAN><SPAN class="s3"><STRONG><EM>$(vMetric)</EM></STRONG></SPAN><SPAN class="s1">),</SPAN><SPAN class="s2">Product</SPAN><SPAN class="s1">,</SPAN><SPAN class="s2">Market</SPAN><SPAN class="s1">),1) </SPAN></P><P class="p1"></P><P class="p1"></P><P class="p1">I need to have a table that has the percentiles by each decile by two dimensions:</P><OL><LI>Percentile</LI><LI>Market</LI></OL><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please help!</SPAN></P><P class="p1"></P><P class="p1"><BR /> </P></BODY></HTML> Tue, 22 Sep 2015 21:36:20 GMT zach_paz 2015-09-22T21:36:20Z Fractile a dynamic variable? https://community.qlik.com/t5/QlikView/Fractile-a-dynamic-variable/m-p/1004452#M650397 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am trying to fractile a dynamic variable that ignores all selections.</P><P></P><P>Variable:</P><UL><LI>vMetric = sum(sales)</LI></UL><P></P><P>Aggregate by:</P><UL><LI>Product</LI></UL><P></P><P>Tables:</P><UL><LI>Percentile<UL><LI>This is a table that has 0% to 100% by 10% increments and is used as the</LI></UL></LI></UL><P></P><P>Current expression:</P><P></P><P class="p1">=fractile<SPAN class="s1">({1&lt;</SPAN><SPAN class="s2">Market</SPAN><SPAN class="s1">=</SPAN>P<SPAN class="s1">(</SPAN><SPAN class="s2">Market</SPAN><SPAN class="s1">)&gt;}</SPAN>aggr<SPAN class="s1">(</SPAN>nodistinct<SPAN class="s1"> (</SPAN><SPAN class="s3"><STRONG><EM>$(vMetric)</EM></STRONG></SPAN><SPAN class="s1">),</SPAN><SPAN class="s2">Product</SPAN><SPAN class="s1">,</SPAN><SPAN class="s2">Market</SPAN><SPAN class="s1">),1) </SPAN></P><P class="p1"></P><P class="p1"></P><P class="p1">I need to have a table that has the percentiles by each decile by two dimensions:</P><OL><LI>Percentile</LI><LI>Market</LI></OL><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Please help!</SPAN></P><P class="p1"></P><P class="p1"><BR /> </P></BODY></HTML> Tue, 22 Sep 2015 21:36:20 GMT https://community.qlik.com/t5/QlikView/Fractile-a-dynamic-variable/m-p/1004452#M650397 zach_paz 2015-09-22T21:36:20Z Re: Fractile a dynamic variable? https://community.qlik.com/t5/QlikView/Fractile-a-dynamic-variable/m-p/1004453#M650398 <HTML><HEAD></HEAD><BODY><P>If you want the expression to ignore all selections the you need to change the expression in the variable too: sum({1} sales).</P></BODY></HTML> Wed, 23 Sep 2015 13:20:43 GMT https://community.qlik.com/t5/QlikView/Fractile-a-dynamic-variable/m-p/1004453#M650398 Gysbert_Wassenaar 2015-09-23T13:20:43Z