Expression to get previous month

[torraroger]

Hi All, 

I'm bulding a Pivot Table that tells me the monthly Average Elapsed Time of each resource (Workbook). 

I have an option, that displays an arrow pinting up or down depending on an expression. 

I need the expression that tells: 

For each month: If the Average Elapsed Time of the previous month is lower ='fa-arrow-up'

See the picture attached.

Thanks.

[jsteyn]

Have you tried the Before() chart function?

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Inter...

Expression would be something like:

=if(Avg(Amount) > Before(Avg(Amount)), 'fa-arrow-up', 'fa-arrow-down')

[torraroger]

It doesn't work...

Thanks!!

[jsteyn]

Can you share your QVF file?

[Gui_Approbato]

Hello Torraroger.

Try the expression

Avg({<Month={'$(=Month-1)'}>}  value)  --> Considering that the months are numerals. If they are not, use month(date).

[Eugene007]

Hi Gui

Please assist me in the below expression to get previous months values.

SUM({<DateKey = {">=$(=Min({<FYP = {"$(=$(vCurrFYP))"}>} DateKey))<=$(=NUM(Date(vToday)))"}, FinancialCode =- {9999}, ProfitCentreCode = {2}, Date= >} RoomsSold)

Kind regards

Eugene