Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.