topic Re: Re: Remove empty column in pivot table in QlikView

Remove empty column in pivot table

Thu, 24 Apr 2014 07:54:42 GMT

I've got a pivot table like this:

How can I move the Country-column to be in the same column as Year, Week and ReportStatus? All should remain the same, I just want to remove the empty space in this column to make the table easier to read. I've tried dragging it but it doesn't work.

If I add a second expression (only have one) then it looks great:

But I don't want more expressions. Any ideas how to move this dimension to be in line with the other?

Re: Remove empty column in pivot table

its_anandrjs — Thu, 24 Apr 2014 07:58:20 GMT

Click on the country dimension and drag it to the right upper corner of the chart and when you drag you see the bluse arrow mark when it display as horizontal leave your dimension there.

Re: Remove empty column in pivot table

Thu, 24 Apr 2014 08:00:49 GMT

Thanks for your answer. However, I don't want this to be horizontal. It should still be a vertical dimension. Everything the same only move the dimension titles one column to the right.

Re: Remove empty column in pivot table

bbi_mba_76 — Thu, 24 Apr 2014 08:03:22 GMT

Hi,

sometimes I used a textbox on the top of the pivot header, then I can set the column width to zero

Re: Remove empty column in pivot table

Thu, 24 Apr 2014 09:04:10 GMT

Hi,

This sounds interesting, could you tell me more how to do it please?

Re: Re: Remove empty column in pivot table

bbi_mba_76 — Thu, 24 Apr 2014 09:29:54 GMT

This is an easy sample

Re: Re: Remove empty column in pivot table

Thu, 24 Apr 2014 09:40:36 GMT

Thank you, I'll see if I can use it.