Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Freeze column in table box?

I have a table box (not a pivot, or a straight table chart) in which all the data displayed is informational, or dimensional, in nature.  However, some of that information is more important that others and I have been asked if there is a way to lock a couple of the columns while allowing the others to scroll - aka Excel.  There are currently 25 columns (most descriptive text) with them wanting to add a few more.  However, they want to be able to keep track of the two or three key columns as they scroll through the rest.

Can this be done?

Thank you.

1 Solution

Accepted Solutions
simondachstr
Luminary Alumni
Luminary Alumni

How about using a straight table and declaring the fixed columns as dimensions, the remaining ones as expressions using =Only(Field)

View solution in original post

2 Replies
simondachstr
Luminary Alumni
Luminary Alumni

How about using a straight table and declaring the fixed columns as dimensions, the remaining ones as expressions using =Only(Field)

Not applicable
Author

Being relatively new to QV, I was not aware of the Only() function.  I'll give it a try and let you know.

...Later...

That does it!  Thank you