Qlik Community

Qlik Sense App Development

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

Highlighted
andreicatalin
New 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
New Contributor III

Re: Pivot table with filtered columns getting extra unknown column

So you want to convert 0 to Nulls or?
andreicatalin
New 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.