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.

[umartareen]

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

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

[#3]

Hi Umar,

Thanks for the quick revert but now after using the expression shared by you,

the Zeros are converted to blank but this is not what i want,

I want to either hide that rows or remove that rows.

[umartareen]

Hi,

In that case you can try this,

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

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

[Anonymous]

Hi Pratik, Did you try checking the Hide Zeros in the presentation tab??

[sravanthialuval]

Please post sample result what your getting.it is leading zero's  problem or simply your getting zero results?

If you want to remove zero values goto presentation tab check the supress Zero-Values.

if you are getting leading zero's simply give num(expression).

[OmarBenSalem]

H Pratik,

Have you tried to uncheck this?

[#8]

Hi Omar,

I am not able to see this option as i am using Qlik Sense table.

[#9]

Hi Sravanthi,

I am not able to see the said option.

I think this option is not available in Qlik Sense table.

[#10]

Hi Shiva,

I am not able to see this option.

Thanks

Pratik