Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
roisolberg
Creator
Creator

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

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

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

CAP2.JPG

 

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

0 Replies