topic Re: Between Years Comparison in QlikView

Between Years Comparison

agomes1971 — Mon, 15 Sep 2014 15:11:09 GMT

Hi,

is it possible to create an expression from a set analysis that compares one year with the previous?

Please see attached.

Thanks

MK_QSL — Mon, 15 Sep 2014 15:16:54 GMT

Current Year

SUM(Sales)

Previous Year

SUM({<Year = {'$(=Max(Year)-1)'}>}Sales)

ecolomer — Mon, 15 Sep 2014 15:19:40 GMT

Try this:

sum({$ < Año={$(=max(Año)-1)} > } Ventas)

where Año (=Year) is the maximun year selected

maxgro — Mon, 15 Sep 2014 22:47:38 GMT

if you mean this the expression is

Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000

above(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000)

agomes1971 — Tue, 16 Sep 2014 08:29:32 GMT

Almost that.

The expresssion I needed was:

(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000

above(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000))/

above(Sum({$<Year={">$(=max(Year)-5)<=$(=max(Year))"}>}Vendas)/1000)

but without your contribution it could not be possible.

Thank you so much

André Gomes