I need to calculate the variation between 2 months in a table. These months are selected according to this script:
=Aggr(Only({<[Análise Mensal] = {'Atual', 'Anterior'}>} [Ano-Mês]) , [Ano-Mês])
Translating:
Análise Mensal = Monthly Analysis
Atual = Current
Anterior = Previous
Ano-Mês = Year-Month
I need to create 9 columns of values calculated based on variations between these 2 months. In Excel file attached "Mix , you can see the calculations that I need to do in the GREEN columns. The BLUE columns are the same that I already have in Qlik, it means, all the measures are in Qlik already. I just don't know how to do the calculations, even they are very simple.
Some measures use less and multiplication operations, and others use average function. Could you help me with it?
Thanks!
