topic Count if (x/stdev(y))&lt;5 in QlikView https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163308#M36455 <HTML><HEAD></HEAD><BODY><P>I need a table that counts only values that fulfill my condition {exp: (x/stdev(y)&lt;5} without the "stdev(y) it works fine like</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">count( if( x&lt;5, x))</PRE>but something like<BR /><BR /> <P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">count( if(stdev(x)&lt;5,x))</PRE>wont work. <BR /><BR /></BODY></HTML> Fri, 21 Aug 2009 19:21:01 GMT 2009-08-21T19:21:01Z Count if (x/stdev(y))<5 https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163308#M36455 <HTML><HEAD></HEAD><BODY><P>I need a table that counts only values that fulfill my condition {exp: (x/stdev(y)&lt;5} without the "stdev(y) it works fine like</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">count( if( x&lt;5, x))</PRE>but something like<BR /><BR /> <P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">count( if(stdev(x)&lt;5,x))</PRE>wont work. <BR /><BR /></BODY></HTML> Fri, 21 Aug 2009 19:21:01 GMT https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163308#M36455 2009-08-21T19:21:01Z Count if (x/stdev(y))<5 https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163309#M36456 <HTML><HEAD></HEAD><BODY><P>Hi, if you trying to use the same field ("x"), remember that inside Count function every value for "x" will be equal to stdev(x), because only that specific x value will be touched.</P><P>Use stdev(TOTAL x) instead.</P></BODY></HTML> Fri, 21 Aug 2009 21:00:08 GMT https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163309#M36456 2009-08-21T21:00:08Z Count if (x/stdev(y))<5 https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163310#M36457 <HTML><HEAD></HEAD><BODY><P>Set analysis might be a better solution if you have dimensions to display.</P></BODY></HTML> Wed, 10 Nov 2010 14:34:24 GMT https://community.qlik.com/t5/QlikView/Count-if-x-stdev-y-lt-5/m-p/163310#M36457 2010-11-10T14:34:24Z