Suppress missing and zero value in Qliksense table

[aatish12345]

Hi All,

In Qlikview we have an functionality where we can supress missing or zero value for our expression in table chart using presentation tab... Hence we are able to see only proper number of records without null.

When I am doing the same in Qliksense Table there the above mentioned options are not available for expression, hence I am seeing null values in expression along with the required records...I want to eliminate the null records from table...

Can someone help me how to do it in Qliksense

Aatish

[MayilVahanan]

Hi @aatish12345 

Try like below - uncheck the zero values

[aatish12345]

Hi Mahil,

Thanks for the reply,

Firstly I made null values to 0 in the expression code after that unchecked include zero value option , but still 0 is visible in the table...that means it is not getting excluded from table after uncheck of the mentioned option.

Aatish

[MayilVahanan]

HI @aatish12345 

Can you send the screenshot or app?

[aatish12345]

 here along with expected values i.e., 833 , 0 is also displaying in the table and I had already unchecked include zero values option from add ons

Aatish