topic Pivot table with filtered columns getting extra unknown column in App Development https://community.qlik.com/t5/App-Development/Pivot-table-with-filtered-columns-getting-extra-unknown-column/m-p/107296#M7329 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm having a pivot table where the columns are filtered like this:</P><P>=If(Match(Parameter.Name,'ABC','DEF','GHI','JKL'), Parameter.Name).</P><P></P><P>So I should be expecting 4 columns. But for some reasons I'm having an extra column with the values of "random" parameters.</P><P></P><P><IMG alt="pivot table.png" class="jive-image image-1" src="/legacyfs/online/211417_pivot table.png" style="height: 98px; width: 620px;" /></P><P></P><P></P><P>Here's how my pivot was built.</P><P></P><P><IMG alt="pivot2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/211421_pivot2.png" style="height: auto;" /></P><P>I played with all the settings and couldn't get it fixed.</P><P></P><P>Any help will be greatly appreciated.</P><P></P><P>Thanks!</P><P></P><P>Simon</P></BODY></HTML> Tue, 21 Aug 2018 14:31:26 GMT Anonymous 2018-08-21T14:31:26Z Pivot table with filtered columns getting extra unknown column https://community.qlik.com/t5/App-Development/Pivot-table-with-filtered-columns-getting-extra-unknown-column/m-p/107296#M7329 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm having a pivot table where the columns are filtered like this:</P><P>=If(Match(Parameter.Name,'ABC','DEF','GHI','JKL'), Parameter.Name).</P><P></P><P>So I should be expecting 4 columns. But for some reasons I'm having an extra column with the values of "random" parameters.</P><P></P><P><IMG alt="pivot table.png" class="jive-image image-1" src="/legacyfs/online/211417_pivot table.png" style="height: 98px; width: 620px;" /></P><P></P><P></P><P>Here's how my pivot was built.</P><P></P><P><IMG alt="pivot2.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/211421_pivot2.png" style="height: auto;" /></P><P>I played with all the settings and couldn't get it fixed.</P><P></P><P>Any help will be greatly appreciated.</P><P></P><P>Thanks!</P><P></P><P>Simon</P></BODY></HTML> Tue, 21 Aug 2018 14:31:26 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-filtered-columns-getting-extra-unknown-column/m-p/107296#M7329 Anonymous 2018-08-21T14:31:26Z Re: Pivot table with filtered columns getting extra unknown column https://community.qlik.com/t5/App-Development/Pivot-table-with-filtered-columns-getting-extra-unknown-column/m-p/107297#M7330 <HTML><HEAD></HEAD><BODY><P>Issue is resolved. I had to uncheck "Include null values" on all rows/columns.</P></BODY></HTML> Tue, 21 Aug 2018 18:39:25 GMT https://community.qlik.com/t5/App-Development/Pivot-table-with-filtered-columns-getting-extra-unknown-column/m-p/107297#M7330 Anonymous 2018-08-21T18:39:25Z