topic Freeze column in table box? in QlikView

Freeze column in table box?

Mon, 11 Aug 2014 14:22:44 GMT

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.

Re: Freeze column in table box?

simondachstr — Mon, 11 Aug 2014 14:29:12 GMT

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

Re: Freeze column in table box?

Mon, 11 Aug 2014 14:33:44 GMT

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