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:
![Cap.JPG Cap.JPG](https://community.qlik.com/t5/image/serverpage/image-id/15016i5BA8533793724433/image-size/medium?v=v2&px=400)
If i take the Qty field off, i get a table without any values.(The desired outcome)
![CAP2.JPG CAP2.JPG](https://community.qlik.com/t5/image/serverpage/image-id/15017iCC648A35272D3F8B/image-size/medium?v=v2&px=400)
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