Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resizing pivot table - is it possible?

I am trying to resize one column in my pivot table (namely the one with the names)

See link: http://imageshack.us/f/841/picsf.png/

the Problem is when i increase the width of the first column so that i can view the full title, the width of columns for the dates becomes bigger too. When I try to decrease the size of the date columns, I can no longer see my title columns. IS there anyway to customize this so that I can see the full titles int eh first columns and not have a huge blank spance in my date columns?

Thank you so much!

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Sure, on the Expressions tab select each expression in turn and choose No Totals as Total Mode.


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Use a straight chart instead and check the Horizontal option on the Presentation tab of the properties window. That way you can resize the column with the expression labels independently of the dimension columns. What you want cannot be done with a pivot table.


talk is cheap, supply exceeds demand
Not applicable
Author

Hmm. So the problem with changing it to a straight chart is I am unable to have my dates on the top. So I'm assuming there is no way around this? It's either dates on top (via pivot table) and no control over column width or straight table (via straight chart) and sacrificing dates on top but having control over column width. Is this correct?

Not applicable
Author

Haha I guess I didn't read all the way. Thanks so much! I guess my only other comment would be is to possile to not show those totals? In the presntation tab, I can change if I want the totals in the beginning or hte end of the tale. Is there anyway to not show the totals?

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Sure, on the Expressions tab select each expression in turn and choose No Totals as Total Mode.


talk is cheap, supply exceeds demand
Not applicable
Author

Perfect. Thanks a lot Gysbert!