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
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

11 Replies
umartareen
Creator II
Creator II

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

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

Not applicable
Author

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
Creator II
Creator II

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] ,))))

laddu_927
Specialist
Specialist

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

sravanthialuval
Creator
Creator

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
Partner - Champion II
Partner - Champion II

H Pratik,

Have you tried to uncheck this?

Capture.PNG

Not applicable
Author

Hi Omar,

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

Not applicable
Author

Hi Sravanthi,

I am not able to see the said option.

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

Not applicable
Author

Hi Shiva,

I am not able to see this option.

Thanks

Pratik