Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table with filtered columns getting extra unknown column

Hi everyone,

I'm having a pivot table where the columns are filtered like this:

=If(Match(Parameter.Name,'ABC','DEF','GHI','JKL'), Parameter.Name).

So I should be expecting 4 columns. But for some reasons I'm having an extra column with the values of "random" parameters.

pivot table.png

Here's how my pivot was built.

pivot2.png

I played with all the settings and couldn't get it fixed.

Any help will be greatly appreciated.

Thanks!

Simon

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Issue is resolved. I had to uncheck "Include null values" on all rows/columns.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Issue is resolved. I had to uncheck "Include null values" on all rows/columns.