topic Re: Straight Table Expression in QlikView https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982217#M335242 <HTML><HEAD></HEAD><BODY><P>May be this as your calculated dimension:</P><P></P><P><STRONG>=If(Aggr(YourExpressionForCount, Name) &gt; 0, Name) </STRONG>and then '<STRONG>Suppress When Value Is Null</STRONG>' on dimension tab.</P></BODY></HTML> Wed, 14 Oct 2015 23:01:29 GMT sunny_talwar 2015-10-14T23:01:29Z Straight Table Expression https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982216#M335241 <HTML><HEAD></HEAD><BODY><P>All, </P><P></P><P>I have a straight table with one single dimension and 8 expressions. Is there a way i can suppress the values of the dimension if they're "0" in say expression 5 or any expression for example?&nbsp; </P><P></P><P>Bad Example, but say this is my straight table. Since "Count" has the two "0" values I want to suppress D and E. Is this possible? Granted the expressions I'm working with are much more extensive.</P><P></P><P></P><P><IMG alt="ex.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/102027_ex.png" style="height: auto;" /></P></BODY></HTML> Wed, 14 Oct 2015 22:52:52 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982216#M335241 2015-10-14T22:52:52Z Re: Straight Table Expression https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982217#M335242 <HTML><HEAD></HEAD><BODY><P>May be this as your calculated dimension:</P><P></P><P><STRONG>=If(Aggr(YourExpressionForCount, Name) &gt; 0, Name) </STRONG>and then '<STRONG>Suppress When Value Is Null</STRONG>' on dimension tab.</P></BODY></HTML> Wed, 14 Oct 2015 23:01:29 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982217#M335242 sunny_talwar 2015-10-14T23:01:29Z Re: Straight Table Expression https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982218#M335243 <HTML><HEAD></HEAD><BODY><P>Yep, that was it. Thanks Sunny!</P></BODY></HTML> Wed, 14 Oct 2015 23:07:07 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982218#M335243 2015-10-14T23:07:07Z Re: Straight Table Expression https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982219#M335244 <HTML><HEAD></HEAD><BODY><P>Not a problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Glad we were able to resolve it quickly.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Wed, 14 Oct 2015 23:17:54 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Expression/m-p/982219#M335244 sunny_talwar 2015-10-14T23:17:54Z