Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

_Tiago07
New Contributor

Calcular a média do Trimeste anterior ao mês atual (Movel)

Preciso calcular a média do Trimestre anterior ao mês atual móvel.

Estou tentando porém só me traz o valor do mês atual =\

sum({<DATA={'>=(=Month(MonthStart(MÁXIMO(DATA)),-3)<(=Month(MonthStart(MÁXIMO(DATA)),0)'}>}VPF)

Tags (1)
1 Reply

Re: Calcular a média do Trimeste anterior ao mês atual (Movel)

MAXIMO is not the function in Qlik where as you can use Max() like

sum({<DATA={">=$(=AddMonths(MonthStart(Max(DATA)),-3))<=$(=Month(MonthStart(Max(DATA))))"}>}VPF)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)