topic Re: how to exclude values with conditions! in QlikView https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568979#M1100368 <HTML><HEAD></HEAD><BODY><P>Add a Calculated Dimension Where CA&gt;'0' AND Suppress Nulls</P></BODY></HTML> Tue, 29 Apr 2014 17:43:23 GMT dseelam 2014-04-29T17:43:23Z how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568972#M1100361 <HTML><HEAD></HEAD><BODY><P>Hello every one , </P><P></P><P>Every day I learn a new thing in Qlikview ; today I have to exclude values from a tables with condition.</P><P></P><P>When "Product_Field"=value then&nbsp; exclude the product . </P><P></P><P>When I have CA=0 , I want to exclude the product from the table . like this screenshot: </P></BODY></HTML> Mon, 28 Apr 2014 16:44:38 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568972#M1100361 2014-04-28T16:44:38Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568973#M1100362 <HTML><HEAD></HEAD><BODY><P>If you want to do SUM of Sales with Excluding Germany....</P><P>Use the same in your application.</P><P></P><P><STRONG style="font-size: 14pt; font-family: Arial, sans-serif;">SUM({&lt;Country -= {'Germany'}&gt;}Sales)</STRONG></P></BODY></HTML> Mon, 28 Apr 2014 16:47:34 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568973#M1100362 MK_QSL 2014-04-28T16:47:34Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568974#M1100363 <HTML><HEAD></HEAD><BODY><P>I want to do : sum ( sales) when CA &gt;0 </P><P>( CA is calculation )</P></BODY></HTML> Mon, 28 Apr 2014 17:02:05 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568974#M1100363 2014-04-28T17:02:05Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568975#M1100364 <HTML><HEAD></HEAD><BODY><P>Where in front end you want to do this logic. On front end do like</P><P></P><P>Expression:-</P><P></P><P>Sum( if(CA&gt;0,sales,0)&nbsp; </P></BODY></HTML> Mon, 28 Apr 2014 17:14:13 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568975#M1100364 its_anandrjs 2014-04-28T17:14:13Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568976#M1100365 <HTML><HEAD></HEAD><BODY><P>You may also use conditions like this:</P><P></P><P>sum({&lt;Product={"=sum(CA)&gt;0"}&gt;}sales)</P><P></P><P>in that case&nbsp; sum(CA)&gt;0 is search string </P><P></P><P>Find set analysis in help and look on "Set Modifiers with Advanced Searches"</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Mon, 28 Apr 2014 19:47:17 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568976#M1100365 2014-04-28T19:47:17Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568977#M1100366 <HTML><HEAD></HEAD><BODY><P>Thank you for your response , but it doesn't work with my Dimension .</P><P>Im using "Product" like dimensions and I want to display only Products with CA &gt;0.</P><P>I don't need to show others . </P></BODY></HTML> Tue, 29 Apr 2014 15:26:52 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568977#M1100366 2014-04-29T15:26:52Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568978#M1100367 <HTML><HEAD></HEAD><BODY><P>I trying to activate condition of the&nbsp; dimension "Produit", if(Sum(CA)&gt;0,Produit,0), else the product will be Hiden.</P><P>This solution doesn't work.</P></BODY></HTML> Tue, 29 Apr 2014 17:35:05 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568978#M1100367 2014-04-29T17:35:05Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568979#M1100368 <HTML><HEAD></HEAD><BODY><P>Add a Calculated Dimension Where CA&gt;'0' AND Suppress Nulls</P></BODY></HTML> Tue, 29 Apr 2014 17:43:23 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568979#M1100368 dseelam 2014-04-29T17:43:23Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568980#M1100369 <HTML><HEAD></HEAD><BODY><P>replace Produit with a calculated dimension </P><P>=if(aggr(sum(CA),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Produit</SPAN>)&gt;0,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Produit</SPAN>)</P><P>and then suppress when value is null</P><P></P><P>I suppose Dariusz's answer works if you apply the same logic to all expression (try with one expression and let we know)</P></BODY></HTML> Tue, 29 Apr 2014 18:44:16 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568980#M1100369 maxgro 2014-04-29T18:44:16Z Re: Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568981#M1100370 <HTML><HEAD></HEAD><BODY><P>It still should work ....</P></BODY></HTML> Tue, 29 Apr 2014 19:20:12 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568981#M1100370 2014-04-29T19:20:12Z Re: how to exclude values with conditions! https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568982#M1100371 <HTML><HEAD></HEAD><BODY><P>HI</P><P>I have weeks showing as 201705 on a chart until 201728</P><P>I need to exclude 201728 so it shows until 201727</P><P></P><P>Plz help if you don't mind</P><P></P><P>Thnx so much</P></BODY></HTML> Thu, 20 Jul 2017 13:52:49 GMT https://community.qlik.com/t5/QlikView/how-to-exclude-values-with-conditions/m-p/568982#M1100371 Anonymous 2017-07-20T13:52:49Z