Can we freeze the expression column and few rows in the table?

[#1]

Hi,

I know that, the dimensions in a table are freezed by default,

but can we freeze the expression column in the table?

can we freeze rows in a table?

[Jason_Michaelides]

What exactly do you mean? Please provide an example in your explanation.

[#3]

probalbly it's about blocking col at pivot table

can we block (freeze) rows? i gueass not...

[#4]

Hi Jason and Pari,

I want to freeze the expression field in the table.

we will get scroll bar when the table width is less right.

that time, if we scroll, then dimension field will remain as freeze.

so like that i want to freeze the expression field.

can we do that?

[#5]

let me look at your qvw file

[jonathandienst]

Hi

So you mean something like the freeze panes function in Excel. As you say, this already happens for dimensions in QV, and I don't know of any way to make an expression column freeze in the same way.

What you may be able to do, is to build a calculated dimension that contains the expression. That expression will then be in the "frozen" part of the chart. You will have to be careful not to affect the chart row construction, probably the best bet is to use an Aggr function like this:

     =Aggr(your expression, Dim1, Dim2, Dim3....)

Where Dim1, 2, 3 etc are the existing chart dimensions. I have not tested this, but I believe that it should work.

Hope that helps

Jonathan

[#7]

Hi,

Thanks for the reply,

I will check it, whether it is possible or not.