I want to remove Zero's from my report but i am not able to do it

[#1]

I have two tables

Table A has Positions against a unique ID

Table B has Joining Status of the candidates against the unique Id created in Table A

Expression which is used to calculate the result is

SUM(positions)-count(if(candidate_status=1014, [budget_city_id-id] ,))

Now, the result which is coming is correct but with some zero values, Now i am not able to remove this Zero values. Please let me know i to do it.

[#2]

Hi Pratix,

In the presentation tab, select 'Suppress Zero-Value' it should resolve you queries.

Regards,

Bhavesh

[OmarBenSalem]

Hi Pratik,

I'm also using a table object in Qlik Sense (straight or dynamic, that does not matter):