Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
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

Capture.JPG

How can i do it in table Qlik Sense ?

 

Thanks in advance 🙂 

Labels (2)
2 Solutions

Accepted Solutions
nisha_rai
Creator II
Creator II

Hi ,

Unchecked the include zero values.

 
 
 
 

Screenshot.PNG

 
 

 

View solution in original post

jmialoundama
Specialist
Specialist
Author

Hi, 

Finlay i use function ROUND to resolv my problem 

ROUND([my_measure],0.01). 

 

View solution in original post

7 Replies
nisha_rai
Creator II
Creator II

Hi ,

Unchecked the include zero values.

 
 
 
 

Screenshot.PNG

 
 

 

jmialoundama
Specialist
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 !

jmialoundama
Specialist
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"

nisha_rai
Creator II
Creator II

Hi,

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

jmialoundama
Specialist
Specialist
Author

Here is my table:

Capture.JPG

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

jmialoundama
Specialist
Specialist
Author

Hi, 

Finlay i use function ROUND to resolv my problem 

ROUND([my_measure],0.01).