Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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 (3)
2 Solutions

Accepted Solutions
Highlighted
Creator II
Creator II

Hi ,

Unchecked the include zero values.

 
 
 
 

Screenshot.PNG

 
 

 

View solution in original post

Highlighted
Creator III
Creator III

Hi, 

Finlay i use function ROUND to resolv my problem 

ROUND([my_measure],0.01). 

 

View solution in original post

7 Replies
Highlighted
Creator II
Creator II

Hi ,

Unchecked the include zero values.

 
 
 
 

Screenshot.PNG

 
 

 

View solution in original post

Highlighted
Creator III
Creator III

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 !

Highlighted
Creator III
Creator III

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"

Highlighted
Creator II
Creator II

Hi,

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

Highlighted
Creator III
Creator III

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

Highlighted
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.

Highlighted
Creator III
Creator III

Hi, 

Finlay i use function ROUND to resolv my problem 

ROUND([my_measure],0.01). 

 

View solution in original post