Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
_Tiago07
Contributor
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)

1 Reply
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful