topic Re: Filtering out data during display in QlikView

Filtering out data during display

Tue, 28 Aug 2012 20:54:10 GMT

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

Re: Filtering out data during display

sreenivas — Wed, 29 Aug 2012 04:54:37 GMT

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

Re: Filtering out data during display

Wed, 29 Aug 2012 13:18:12 GMT

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,

Re: Filtering out data during display

whiteline — Mon, 03 Sep 2012 11:50:25 GMT

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

Re: Filtering out data during display

Tue, 04 Sep 2012 14:02:13 GMT

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,