topic Re: Excluding the values from pivot table in QlikView

Excluding the values from pivot table

Fri, 15 Aug 2014 10:44:42 GMT

Hello all,

I need some help with a small problem.

As you can see below, I need to exclude the value from the dimension. That is in red rectangle, so the values from blue rectangle should not be calculated.

Any help would be nice,

Thanks in advance

Re: Excluding the values from pivot table

maleksafa — Fri, 15 Aug 2014 10:54:10 GMT

suppress null values from you chart/dimension

Re: Excluding the values from pivot table

MK_QSL — Fri, 15 Aug 2014 11:06:28 GMT

Go to dimension tab

Select your dimension

tick suppress when value is null...

if this is not solving your problem, please provide sample data.

Re: Excluding the values from pivot table

Fri, 15 Aug 2014 12:54:13 GMT

On the Dimension tab, Select the "Suppress When Value is Null"