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: 
vlad_komarov
Partner - Specialist III
Partner - Specialist III

Keeping Column's size and position frozen in the Straight and Pivot tables

Hello!

I have a request to freeze columns (their width and initial position) in most of the tables in my application.

I've tried to use "Read Only" option, but first of all it is not providing me a required result (the columns are still flexible) and second of all, some of y table still need to receive an input from the user.

I would appreciate any suggestion about how to handle this request.

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

Vlad,

Right-click on the sheet, select Sheet Properties. Go to the Security tab. Uncheck "Move/Size Sheet Object," check "Apply to All Sheets," and press OK. That should take care of the column widths.

Next, in the chart go to the Presentation tab and uncheck "Allow Drag and Drop." That should take care of column positions.

Cheers,

View solution in original post

3 Replies
vgutkovsky
Master II
Master II

Vlad,

Right-click on the sheet, select Sheet Properties. Go to the Security tab. Uncheck "Move/Size Sheet Object," check "Apply to All Sheets," and press OK. That should take care of the column widths.

Next, in the chart go to the Presentation tab and uncheck "Allow Drag and Drop." That should take care of column positions.

Cheers,

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

It was quick! I should probably just call you directlyBig Smile

Thanks, it works exactly as I needed.

Regards,

vgutkovsky
Master II
Master II

This way we both get some forum points out of it too 🙂