topic Re: Filter straight table with expression results in QlikView https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955808#M974052 <HTML><HEAD></HEAD><BODY><P>in dimension tab you will be have supress when null option use it</P></BODY></HTML> Thu, 03 Sep 2015 05:40:25 GMT gautik92 2015-09-03T05:40:25Z Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955805#M974049 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I am very new to QV:) I have a straight table with 3 dimensions and 2 expressions. I wanted to filter out the rows in where both expression1 and expression2 have null or zero values.</P><P>Do you know how can I do it?</P><P></P><P></P><P>Trying to find a workaround, I tried to create an additional expression to flag the rows in where both expressions are null or zero. It does flag the rows, but I do not know how to filter out based on this expression result.</P><P></P><P>Thanks!!!!</P></BODY></HTML> Wed, 02 Sep 2015 09:19:32 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955805#M974049 2015-09-02T09:19:32Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955806#M974050 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Did you try 'Suppress when value is Null' in Dimension tab and Suppress zero values in expression tab?</P><P></P><P>Thanks,</P><P>Digvijay</P></BODY></HTML> Thu, 03 Sep 2015 05:30:48 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955806#M974050 Digvijay_Singh 2015-09-03T05:30:48Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955807#M974051 <HTML><HEAD></HEAD><BODY><P>Please share always sample data and app for faster response from community.</P></BODY></HTML> Thu, 03 Sep 2015 05:31:47 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955807#M974051 Digvijay_Singh 2015-09-03T05:31:47Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955808#M974052 <HTML><HEAD></HEAD><BODY><P>in dimension tab you will be have supress when null option use it</P></BODY></HTML> Thu, 03 Sep 2015 05:40:25 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955808#M974052 gautik92 2015-09-03T05:40:25Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955809#M974053 <HTML><HEAD></HEAD><BODY><P>Remove your flag expression and make sure '<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> Suppress zero values' is checked in the expression tab.</SPAN></P></BODY></HTML> Thu, 03 Sep 2015 06:18:25 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955809#M974053 jonathandienst 2015-09-03T06:18:25Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955810#M974054 <HTML><HEAD></HEAD><BODY><P>I had already checked the "Suppress zero values" in the expression tab. Rows will still show because the dimensions displayed in the table are not null.</P><P></P><P>The straight table has 3 dimensions and 2 expressions.What I would like to do is to not display the dimension rows in case two of the expressions are both null. Is it possible to not display dimensions depending on the value of an expression??</P><P>Thank you!</P></BODY></HTML> Thu, 03 Sep 2015 08:20:48 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955810#M974054 2015-09-03T08:20:48Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955811#M974055 <HTML><HEAD></HEAD><BODY><P>It shouldn't show dimension if values are null, check if you have activated this in dimension tab - </P><P><IMG alt="all values.PNG" class="jive-image image-1" src="/legacyfs/online/97834_all values.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 03 Sep 2015 08:31:09 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955811#M974055 Digvijay_Singh 2015-09-03T08:31:09Z Re: Filter straight table with expression results https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955812#M974056 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Thu, 03 Sep 2015 13:51:34 GMT https://community.qlik.com/t5/QlikView/Filter-straight-table-with-expression-results/m-p/955812#M974056 2015-09-03T13:51:34Z