topic Re: Removing null columns in pivot table. in QlikView

Removing null columns in pivot table.

nsm1234567 — Fri, 24 Mar 2017 06:21:15 GMT

Hi there,

I'm wondering if there is a way to manipulate a pivot table for a report I'm trying to build. If you look at the attachment (also see screenshot below), you'll see I've built a pivot table with report headers. Ideally, I'd like to display the Week, Month and Year columns for all the headers except "Contributed Growth." For "Contributed Growth" I only want to show the month column. In other words, the columns that reflect as "null" I want to not display. I've tried a few things without success. Is this possible?

Re: Removing null columns in pivot table.

Anonymous — Fri, 24 Mar 2017 07:48:58 GMT

Hi,

I tried doing a valuelist for this one.

Dimensions:

1. Business Unit

2. ReportHeader

3.=ValueList('Week','Month','Year')

Expression:

=if(ReportHeader='Contributed Growth', if(ValueList('Week','Month','Year')='Month', sum([Business Unit])),

sum([Business Unit]))

I'm not sure if there are better ways

Re: Removing null columns in pivot table.

nsm1234567 — Fri, 24 Mar 2017 12:39:58 GMT

Thanks a lot, I was able to get a variation of that to work in my app.

Thanks for the assistance.