Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table dimension between columns

Hi guys,

Could you explain how to get different sizes for columns in pivot table.

I have 1 dimension and 3 expressions.

Names of expressions I want to have bigger, but result is smaller.

Capture.JPG.jpg

Sometimes it works with 1 dimension, sometimes with 2 level of dimensions.

Thanks,

9 Replies
bgerchikov
Partner - Creator III
Partner - Creator III

Hi,

You need to activate Design Grid, Right click on desired cell and select Custom Format Cell. In the open menu you can modify text format for headers or columns

Hope it will hellp

Anonymous
Not applicable
Author

Thanks for reply.

I want to column Feb 2014 make smaller. Left column keep the same size.

Capture.JPG.jpg

Now they are equal column widht

Regards,

bgerchikov
Partner - Creator III
Partner - Creator III

In this case just put the mouse cursor on the column border, you will see the new type of cursor, left click and keep it, then you can change the column width.

PrashantSangle

Hi,

Actually

Keep your arrow on left of header you will see + sign of icon Press and change your width of your pivot table

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Anonymous
Not applicable
Author

Could you add more screen shots?

Capture.JPG.jpg

bgerchikov
Partner - Creator III
Partner - Creator III

When you hoover over column border you might see cursor like in attachment, Once you see it - left click and move mouse left or right.

Anonymous
Not applicable
Author

No, it keeps equal widht for both cells.

Please see my attached file.

antoniotiman
Master III
Master III

You cannot resize only the column because this is dimension.

If you reverse dimension with expression you can do it.

Regards

bgerchikov
Partner - Creator III
Partner - Creator III

Ya, I see... After such transformation you cannot do a lot. I'd suggest, if it's so necessary, to create dummy table/list box for the expression labels.