topic Re: Setting limits without hard values in QlikView https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347117#M414458 <HTML><HEAD></HEAD><BODY><P>Thank you</P><P></P><P>I forgot about the $ </P></BODY></HTML> Fri, 07 Jul 2017 10:01:59 GMT Anonymous 2017-07-07T10:01:59Z Setting limits without hard values https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347115#M414456 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I am trying to find the number of the lowest 20% of a field</P><P></P><P>So the expression I was trying to use was</P><P><A> --- Field Name </A></P><P></P><P>Count({&lt; <A> = {'&gt;0&lt;({Max(A)/100*20})'} &gt;} </A><A>)</A></P><P></P><P>Instead of the expression with hard values which does work</P><P></P><P>Count({&lt; <A> = {'&gt;0&lt;20'} &gt;} </A><A>)</A></P><P></P><P>My idea was that even if more values were added it would still count the lowest 20% of values</P><P>If there is a way to correct advise would be appreciated</P><P></P><P>Thank you</P></BODY></HTML> Fri, 07 Jul 2017 09:53:54 GMT https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347115#M414456 Anonymous 2017-07-07T09:53:54Z Re: Setting limits without hard values https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347116#M414457 <HTML><HEAD></HEAD><BODY><P>May be like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count({&lt; <A> = {'&gt;0 &lt; <STRONG>$(=Max(A)/100*20)</STRONG>' } &gt;} </A><A>)</A></SPAN></P></BODY></HTML> Fri, 07 Jul 2017 09:56:33 GMT https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347116#M414457 tresB 2017-07-07T09:56:33Z Re: Setting limits without hard values https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347117#M414458 <HTML><HEAD></HEAD><BODY><P>Thank you</P><P></P><P>I forgot about the $ </P></BODY></HTML> Fri, 07 Jul 2017 10:01:59 GMT https://community.qlik.com/t5/QlikView/Setting-limits-without-hard-values/m-p/1347117#M414458 Anonymous 2017-07-07T10:01:59Z