topic Re: Pivot table in QlikView

Pivot table

Thu, 27 Sep 2012 02:11:19 GMT

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.

Re: Pivot table

Thu, 27 Sep 2012 02:58:16 GMT

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

Re: Pivot table

Thu, 27 Sep 2012 21:18:41 GMT

Yes You are right but how to remove it.

Re: Pivot table

MayilVahanan — Thu, 27 Sep 2012 21:45:44 GMT

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

Re: Pivot table

Fri, 28 Sep 2012 01:56:13 GMT

Hi,

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

Regards,

Janzen

Re: Pivot table

Fri, 05 Oct 2012 16:40:26 GMT

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.

Re: Pivot table

whiteline — Sat, 06 Oct 2012 10:21:39 GMT

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.