Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to exclude or hide values in a report

I do not want to show the values 0.00 in my report.I have already used the option suppress null value but still I am getting them.How can I hide them?

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Null values are different from 0.00000 values. Null values only appear when a field has no data for that record, so naturally, the 0.000 is a value.

That said, in case this is a measure, it could as well be that these aren't zero values, but it is a result with lots of zeros after the decimal.

You could always do an If-check in your script on [Fuel per last ...] for checking if the value is 0. If it is zero, give it the value Null(). This will allow you to use the Suppress null values.

Example:

If([Fuel per last ...] =0, Null(), [Fuel per last ...])

View solution in original post

8 Replies
Highlighted
Specialist
Specialist

Null values are different from 0.00000 values. Null values only appear when a field has no data for that record, so naturally, the 0.000 is a value.

That said, in case this is a measure, it could as well be that these aren't zero values, but it is a result with lots of zeros after the decimal.

You could always do an If-check in your script on [Fuel per last ...] for checking if the value is 0. If it is zero, give it the value Null(). This will allow you to use the Suppress null values.

Example:

If([Fuel per last ...] =0, Null(), [Fuel per last ...])

View solution in original post

Highlighted
Creator III
Creator III

Currently I tried the following codes

If([Fuel per last Noon] =0.000, Null(), [Fuel per last Noon]) and related but I got this value.Now I want to hide this whole row..what should I do?

Highlighted
Contributor II
Contributor II

can you provide expressions for more information

Highlighted
Creator III
Creator III

Hi,

Check suppress null value for [Fuel per last Noon] dimension .

Thanks,

Pooja

Highlighted
Creator III
Creator III

timpoismans‌ I rearranged the dimensions and it is working fine.Thanks for your help

Highlighted
Specialist
Specialist

You should be able to hide null values per expression in your table. If you hide them for each expression, the row with null values for each expression shouldn't show in the table.

Highlighted
Specialist
Specialist

You're welcome!

Highlighted
Creator III
Creator III

Hi Govind,

Thanks for the enquiry but the question is closed and answered.

Regards,

Trishita