Hide zero in table Qlik Sense

[jmialoundama]

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 ?

Thanks in advance 🙂 

[nisha_rai · Accepted solution]

Hi ,

Unchecked the include zero values.

[jmialoundama]

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 !

[jmialoundama]

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"

[nisha_rai]

Hi,

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

[jmialoundama]

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

[nisha_rai]

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.

[jmialoundama · Accepted solution]

Hi, 

Finlay i use function ROUND to resolv my problem 

ROUND([my_measure],0.01).