topic Re: Freeze panes excel style? in QlikView

Freeze panes excel style?

Anonymous — Wed, 13 Feb 2013 11:02:43 GMT

I have a table box with two dimensions (Product Group, Department) and sales for months with their budgets etc,. Anyway, I want to reference a column with sales last year and earlier as fixed (next to the columns of the dimensions), the style of the excel freeze panes. Is it possible?.

Thank you all.

Felix

Re: Freeze panes excel style?

sushil353 — Wed, 13 Feb 2013 11:42:02 GMT

can you provide any sample of your requirement

Re: Freeze panes excel style?

Anonymous — Wed, 13 Feb 2013 12:36:26 GMT

The first two columns, when dimensions are fixed, the other has a horizontal scroll. I would like the column Sales 2001 Sales 2012 are fixed, as the first two and no scroll.

Thank you!

Re: Freeze panes excel style?

Gysbert_Wassenaar — Wed, 13 Feb 2013 21:16:16 GMT

In a pivot table the dimensions (both vertical and horizontal) are always fixed. If you want 'reference' columns you'll have to add them as calculated dimensions.

Something like =aggr(sum(Sales 2011),[Product Group],[Dpto.]) if you have a field Sales 2011. Maybe =aggr(sum({<Year={2011}>}Sales),[Product Group],[Dpto.]) if you have a field Year and a field Sales.

I don't know the names of your fields, only the labels from your screenshot, so change the names in the expression to whatever your field names are.

Re: Freeze panes excel style?

Anonymous — Wed, 13 Feb 2013 21:22:37 GMT

use a straight table instead of table box . Define the set analysis value in expressions and Dimension in the Dimensions that will fix your issue. Or esle send us the sample data we can help you with the issue easily.

Re: Freeze panes excel style?

Anonymous — Thu, 14 Feb 2013 08:33:53 GMT

Perfect, it works correctly. thank you very much Gisbert!!!

Re: Freeze panes excel style?

Anonymous — Thu, 14 Feb 2013 08:38:53 GMT

Vinay thank you very much!, Gysbert solution has worked for me the first time.

Thank you both!