topic Re: Lock pivot table dimension column in QlikView

Lock pivot table dimension column

Thu, 20 Sep 2012 12:38:20 GMT

I have a pivot table in QV11 with one dimension (date), which is across the top, and about 30 expressions. i would like to keep the first column showing the last day of the previous year, and possibly a few others for month-ends. i would also like to have another column that will change with a date selection. anybody know the best way to pull this off?

12/31/2011(fixed) 9/19/2012 (changes with selection)

exp1

exp2

exp3

exp4

exp5

...

i should also add that the date is loaded from a table and the expressions are made up of set analysis on info from a table.

Re: Lock pivot table dimension column

Anonymous — Thu, 20 Sep 2012 20:37:43 GMT

Looks like it can be done by using calculated dimension for Date using set analysis, so that it will show selected Dates plus some "hard-coded" in the set expression.

See help on set analysis, there are examples how to do this.

Regards,

Michael

Re: Lock pivot table dimension column

Fri, 21 Sep 2012 12:07:29 GMT

thanks Michael. i was having some trouble finding the right function to use with the set analysis. I appreciate the help though.

Re: Lock pivot table dimension column

Anonymous — Fri, 21 Sep 2012 12:56:49 GMT

This solution works for me:

1. Calculated expression for Date:
=aggr(only({<Date+={'12/31/2011'}>} Date),Date)

2: Condition in chart expression to ignore Date selection (in each expression if there are many):
=sum({Date=} field)

Regards,
Michael

Re: Lock pivot table dimension column

Fri, 21 Sep 2012 13:51:15 GMT

Thanks Michael.