topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

Tue, 26 Jan 2016 15:38:33 GMT

Hello my friends!!

A question about SET ANALYSIS

I want to show allways the data for December for the previous year in the following scritp:

=Avg({< Month={'Dec'}, Year=, MonthYear=, QuarterYear=,PAÍS=,Country=,NivelJerarquia={1}>}Nota)

What I have to do in the field YEAR in order to show the previous one

Regards!

maxgro — Tue, 26 Jan 2016 20:19:09 GMT

Avg({<

Month={'Dec'},

Year={$(=Max(Year)-1)},

MonthYear=, QuarterYear=,PAÍS=,Country=,NivelJerarquia={1}>}

Nota)

Wed, 27 Jan 2016 08:43:44 GMT

Many thanks!! it works!