Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Remove empty column in pivot table

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?

6 Replies

Re: Remove empty column in pivot table

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.

Not applicable

Re: Remove empty column in pivot table

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.

bbi_mba_76
Valued Contributor

Re: Remove empty column in pivot table

Hi,

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

Not applicable

Re: Remove empty column in pivot table

Hi,

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

bbi_mba_76
Valued Contributor

Re: Re: Remove empty column in pivot table

This is an easy sample

Not applicable

Re: Re: Remove empty column in pivot table

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

Community Browser