Table has no values, but still hold a line for the measure

[roisolberg]

Hi All,

i have  a table that i created and i send it daily from my Qlik NP console.

the issue is that when the table has no values it should not be sent.

the table is sent anyway as the measure column is calculated and when i have no data my table looks like:

If i take the Qty field off, i get  a table without any values.(The desired outcome)

the Qty field is calculated variable "if(isnull(SerialNumber),ItemQty,1)"

my question how do i make it to not show null values..

Thanks!

Roi