Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What exactly do you mean? Please provide an example in your explanation.
probalbly it's about blocking col at pivot table
can we block (freeze) rows? i gueass not...
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?
let me look at your qvw file
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
Hi,
Thanks for the reply,
I will check it, whether it is possible or not.