Pivot table

[#1]

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.

[#2]

Hi,

Maybe it is an expression that you have dragged in to columns. Isn't it? Or probably the label of the dimension is a blank space.

Regards,

Janzen

[#3]

Yes You are right but how to remove it.

[MayilVahanan]

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

[#5]

Hi,

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

Regards,

Janzen

[#6]

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]

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.