topic Re: Filter on a calculated Value in QlikView https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753156#M1034284 <HTML><HEAD></HEAD><BODY><P>You can use dimension limits to restrict the customers.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2720">QlikView 11 Dimension Limit Functionality</A></P></BODY></HTML> Thu, 22 Jan 2015 18:51:15 GMT Colin-Albert 2015-01-22T18:51:15Z Filter on a calculated Value https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753154#M1034282 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I would like to be able to filter on a calculated value (like the monthly revenue for example). </P><P></P><P>I have all sort of charts and I would like to see appearing only the customers Which monthly income is superior to a certain value.</P><P></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>Customer </STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Monthly income</STRONG></TH></TR><TR><TD style="padding: 2px;">Customer 1 </TD><TD style="padding: 2px;">10000€</TD></TR><TR><TD style="padding: 2px;">Customer 2</TD><TD style="padding: 2px;">20000€</TD></TR><TR><TD style="padding: 2px;">Customer 3</TD><TD style="padding: 2px;">500€</TD></TR></TBODY></TABLE><P></P><P>I would like to be able to select only customer 1 and 2 (revenue above 1000€)</P><P></P><P>This sound basic but I'm stuck <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 22 Jan 2015 18:32:53 GMT https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753154#M1034282 2015-01-22T18:32:53Z Re: Filter on a calculated Value https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753155#M1034283 <HTML><HEAD></HEAD><BODY><P>Hi Martin,</P><P></P><P>select "straight table chart"</P><P>take the "customer" field in dimensions</P><P>expression:-if(Amount&gt;1000,Amount)</P><P></P><P>i hope it will work</P></BODY></HTML> Thu, 22 Jan 2015 18:47:14 GMT https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753155#M1034283 ramasaisaksoft 2015-01-22T18:47:14Z Re: Filter on a calculated Value https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753156#M1034284 <HTML><HEAD></HEAD><BODY><P>You can use dimension limits to restrict the customers.</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2720">QlikView 11 Dimension Limit Functionality</A></P></BODY></HTML> Thu, 22 Jan 2015 18:51:15 GMT https://community.qlik.com/t5/QlikView/Filter-on-a-calculated-Value/m-p/753156#M1034284 Colin-Albert 2015-01-22T18:51:15Z