Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andreicatalin
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
NhanNguyen
Contributor III
Contributor III

So you want to convert 0 to Nulls or?
andreicatalin
Contributor II
Contributor II
Author

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.