topic Re: Hint: How to filter Dimensions Based on complex Calculations in QlikView https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369384#M575073 <HTML><HEAD></HEAD><BODY><P>Nice! Thanks!</P></BODY></HTML> Thu, 28 Jun 2012 13:11:24 GMT 2012-06-28T13:11:24Z Hint: How to filter Dimensions Based on complex Calculations https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369381#M575070 <HTML><HEAD></HEAD><BODY><P>To filter dimensions based on complex calculations I use the following way:</P><P></P><P>Use the Pareto Select as an action in a button. The trick is the expression.</P><P>Put your condition in the form</P><P>If( condition = true, 1,0) and select the percentage as 50.</P><P>The condition can be really complex. Don't use "=" at the beginning of the expression in front of if (bug ?).</P><P></P><P>Together with a select excluded button, this is very powerful and user friendly.</P><P></P><P>I hope this is interesting for you.</P><P></P><P>Norbert</P></BODY></HTML> Tue, 26 Jun 2012 20:56:03 GMT https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369381#M575070 Anonymous 2012-06-26T20:56:03Z Re: Hint: How to filter Dimensions Based on complex Calculations https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369382#M575071 <HTML><HEAD></HEAD><BODY><P>Could you post a small exempel? I don't really fellow (ok it is late over here...). But I'm curious! </P><P></P><P>Thanks in advance!</P></BODY></HTML> Tue, 26 Jun 2012 21:20:33 GMT https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369382#M575071 2012-06-26T21:20:33Z Re: Hint: How to filter Dimensions Based on complex Calculations https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369383#M575072 <HTML><HEAD></HEAD><BODY><P>Roberto, please see attached example.</P><P>Regards</P><P>Norbert</P></BODY></HTML> Wed, 27 Jun 2012 18:46:02 GMT https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369383#M575072 Anonymous 2012-06-27T18:46:02Z Re: Hint: How to filter Dimensions Based on complex Calculations https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369384#M575073 <HTML><HEAD></HEAD><BODY><P>Nice! Thanks!</P></BODY></HTML> Thu, 28 Jun 2012 13:11:24 GMT https://community.qlik.com/t5/QlikView/Hint-How-to-filter-Dimensions-Based-on-complex-Calculations/m-p/369384#M575073 2012-06-28T13:11:24Z