Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Pivot table with filtered columns getting extra unknown column

Hi there,

 

I am trying to put together a pivot that shows data (both nulls and values) per a few categories (delete headers below) across a few months.

In some months there is data - in some, there isn't. I want to be able to show both.

 

The pivot returns this odd column - highlighted with 0s and null values. Any Insight as to how to get rid of it & have a clean table showing months with 0 and months with values?pivottable.PNG 

2 Replies
Highlighted
Contributor III
Contributor III

Re: Pivot table with filtered columns getting extra unknown column

So you want to convert 0 to Nulls or?
Highlighted
Contributor II
Contributor II

Re: Pivot table with filtered columns getting extra unknown column

Thanks for getting back. 

 

I want to essentially remove the column with a null header. 

I have column titles all across (although I obscured them in the screenshot). I essentially want the following:

             Column1         Column 2     Column 3

Jan      0                         0                       0

Feb     0                          0                       0

Mar      0                         0                       0

Apr     0                          0                       0

May    58.1                  1.3                    0.3

etc.