Pivot table - Qlik Community

Ditto - same here! · ‎2012-09-26

Hi,

In the Pivot table i have dragged a dimension in to columns and it created a blnk space in the Pivot header . Is it possible to remove it. Attached the snapshot for the reference.

Report Inappropriate Content · ‎2012-09-27

Yes You are right but how to remove it.

MayilVahanan · ‎2012-09-27

Hi

I think, its can't remove field, but can use custom format cell, and remove the border cell ..

Use Design grid for appear custom format cell

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2012-09-27

Hi,

Remove any spaces in the label field for all of your dimensions. Please see attached screenshot.

Regards,

Janzen

Report Inappropriate Content · ‎2012-10-05

Thanks for your response Janzen, The screenshot is for the Qlikview 11. I am using Qlikview 10 . However i tried your option but still the space is there. I couldnt hide it.

whiteline · ‎2012-10-06

Hi.

You can't hide it in pivot since it's the header for your months dimension.

It's also used to drag'n'drop dimensions.

You could use straight table, but it results in a separate expression for each month.