how do i not display null data in a table

[#1]

im in qlik sense cloud

i am showing data in a table from upload xls files.

i have null rows showing and do not want to show rows with no values

i have unchecked under Data Handling the "SHow zero values" check box.

[sinanozdemir]

In your expression, you could do something like this:

Sum({<Company = {"*"}>}Amount)

* would sum everything, but NULL values.

[reddy-s]

Hi Michael,

There is an other checkbox under the dimension properties which will restrict the null Values. Its worth giving a try.

Thanks and Regards,

Sangram Reddy,