Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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?

Tags (2)
6 Replies
jason_michaelid
Honored Contributor II

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

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

Not applicable

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

probalbly it's about blocking col at pivot table

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

Not applicable

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

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?

Not applicable

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

let me look at your qvw file

MVP
MVP

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

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

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

Hi,


Thanks for the reply,

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

Community Browser