https://community.qlik.com/t5/QlikView/hide-null-in-the-expression/m-p/1593742#M738729 <P>Hi guys,</P><P>I have a pivot table, where I use a rank function as an expression and want to show only 10 tops among all selection and I want to hide the null rows.</P><P>I have used the expression as such:</P><P>if(rank (sum (UnitCost*UnitsBalance),4)&lt;=10, rank (sum (UnitCost*UnitsBalance)), Null())</P><P>I have turned the suppress when value is null and suppressed Zero-Values for all Columns in Presentation TAb.</P><P>&nbsp;</P><P>I know how it is possible to use with AGGR function and did it already. However, is there&nbsp; a solution that I can simply edit my expression above?</P> Sat, 16 Nov 2024 20:37:45 GMT McDataMan 2024-11-16T20:37:45Z https://community.qlik.com/t5/QlikView/hide-null-in-the-expression/m-p/1593742#M738729 <P>Hi guys,</P><P>I have a pivot table, where I use a rank function as an expression and want to show only 10 tops among all selection and I want to hide the null rows.</P><P>I have used the expression as such:</P><P>if(rank (sum (UnitCost*UnitsBalance),4)&lt;=10, rank (sum (UnitCost*UnitsBalance)), Null())</P><P>I have turned the suppress when value is null and suppressed Zero-Values for all Columns in Presentation TAb.</P><P>&nbsp;</P><P>I know how it is possible to use with AGGR function and did it already. However, is there&nbsp; a solution that I can simply edit my expression above?</P> Sat, 16 Nov 2024 20:37:45 GMT https://community.qlik.com/t5/QlikView/hide-null-in-the-expression/m-p/1593742#M738729 McDataMan 2024-11-16T20:37:45Z https://community.qlik.com/t5/QlikView/hide-null-in-the-expression/m-p/1593806#M738730 <P>Would you be able to share a sample to show the issue?</P> Wed, 19 Jun 2019 18:38:04 GMT https://community.qlik.com/t5/QlikView/hide-null-in-the-expression/m-p/1593806#M738730 sunny_talwar 2019-06-19T18:38:04Z