Filtering out data during display

[#1]

I am new to quick view and is trying to create bar chart where I need to filter out a field where it has no value. These records needs to be bypass all togehter so that when I do the total count on the "expressions", it will not be included. I am using QlikView 11.0.

Any help will be greatly appreciate it.

Regards,

Tak

[sreenivas]

In Dimensions tab check the "Suppress when value is null"

[#3]

Hi Sreenivas:

The issue is that the field that I want to check is not the one being used for display. How do I go about telling it to check for a specific fields for null and then to bypass it?

Thanks,

[whiteline]

Do u want to filter some values that your sum or dimension values on a bar chart ?

[#5]

No. It is a derived value but came from the Excel that I uploaded. I needed these values to be included in a summary sheet that I will be creating but have to be filter out from the bar chart on my detail sheet and is not used anywhere on the detail sheet..

Thanks,