Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jmialoundama
Specialist
Specialist

Hide line less 0 qlik sense

Hello,

I would like to delete the lines which contain 0 and -0.

I unchecked the box "Include the values ​​at zero" however the line which contains the zero and the "-0" always appears.

How to make this line disappear?

Capture.JPG

thank you in advance

Labels (3)
1 Solution

Accepted Solutions
jmialoundama
Specialist
Specialist
Author

In fact I had values ​​behind this zero.

So I used the round function to round to 2 decimal places after the decimal point and so the zeros were removed from my table

Round(My_measure,0.01)

View solution in original post

2 Replies
lorenzoconforti
Specialist II
Specialist II

if it's showing -0 probably it's not 0. First try to understand if it's really a 0 value

jmialoundama
Specialist
Specialist
Author

In fact I had values ​​behind this zero.

So I used the round function to round to 2 decimal places after the decimal point and so the zeros were removed from my table

Round(My_measure,0.01)