Announcements
cancel
Showing results for
Did you mean:
Specialist

## Hide zero in table Qlik Sense

Hi,

I don't want to display the lines when :

BALANCE M YTD = 0 AND BALANCE M-1 YTD = 0 AND BALANCE M PERIOD  = 0 AND BALANCE M-1 PERIOD = 0

How can i do it in table Qlik Sense ?

Labels (2)

• ### Hide zero

2 Solutions

Accepted Solutions
Creator II

Hi ,

Unchecked the include zero values.

Specialist
Author

Hi,

Finlay i use function ROUND to resolv my problem

ROUND([my_measure],0.01).

7 Replies
Creator II

Hi ,

Unchecked the include zero values.

Specialist
Author

Thanks NISHA ! 🙂

I was looking for this option but I did not find it in the parameters of the Qlik table

That's perfect, thank you very much !

Specialist
Author

Hi,

I have an other problem.

When my result is less than zero checking the box "Include zero values" does not hide my line which contains "-0"

Creator II

Hi,

Can you share the sample data . so that i can provide you the exact solution

Specialist
Author

Here is my table:

Here are the formulas I have :

BALANCE M PERIOD : =Sum({<VERSION={'YTD'}>}[BAL_BALANCE_M] +[BAL_BALANCE_PYC_M]);

BALANCE M PERIOD : =Sum({<VERSION={'MONTH'}>}[BAL_BALANCE_M] +[BAL_BALANCE_PYC_M])-Sum({<VERSION={'MONTH'}>}[BAL_BALANCE_PYC_M]);

BALANCE M-1 PERIOD : =Sum({<VERSION={'MONTH'}>}[BAL_BALANCE_M_1] +[BAL_BALANCE_PYC_M_1])-(SUM({<VERSION={'MONTH'}>}[BAL_BALANCE_PYC_M_1]));

Creator II

Hi ,

Because that is not the exactly 0, may be the amount is -0.222/-0.0222* something, that including zero value check box only work when value is exactly 0.

Specialist
Author

Hi,

Finlay i use function ROUND to resolv my problem

ROUND([my_measure],0.01).