Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Excluding the values from pivot table

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

3 Replies
maleksafa
Valued Contributor

Re: Excluding the values from pivot table

suppress null values from you chart/dimension

Capture.PNG.png

Re: Excluding the values from pivot table

Go to dimension tab

Select your dimension

tick suppress when value is null...

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

Not applicable

Re: Excluding the values from pivot table

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

Community Browser