topic Comparing years when year is a dimension in QlikView

Comparing years when year is a dimension

Tue, 17 Jan 2012 11:58:05 GMT

Hi All,

I wondered if anyone had an expression based solution to the following problem.

If I have sales data and I want to do a table that has Transaction_Year as the dimension (e.g. 2008, 2009, 2010, 2011) and I want to display the following two expressions:

- Sum(Sales) by year (simple.)

- Sum(Sales) for the year prior to the year of the current dimension. So in the 2011 column, I would have the Sum(Sales) for 2010. This would allow me to develop the formula to do a % change in the same table as the year exists as a dimension.

I want to achieve this without using an independent table and IF statements which is very inefficient for large data sets.

Thanks

Comparing years when year is a dimension

nstefaniuk — Tue, 17 Jan 2012 13:49:52 GMT

Hello

You can

- pre-calculate

- use Chart Inter Record functions Above/Below/Before/After but they have restrictions

- use If (sorry)

You can't

- use a dynamic Set Analysis

Chart Inter Record functions

Comparing years when year is a dimension

Tue, 17 Jan 2012 15:01:29 GMT

Thanks very much I had not known about the Above/Below/Before/After but this was exactly what I was looking for!