Set Analysis Table Previuos Month

[Pdmotta]

I believe it´s easy but I don´t get it.

In an accounting balance sheet I need to show in a table the total of an accounting balance sheet in a month and the previuos month total

Acount	MonthYear	Total	Previuos Month
Asset	feb 2021	12345.67	10030.00
Cash	feb 2021	23456.78	20999.99

Where "Previuos Month" refers to to Total of jan/2021

I´ve tried

SUM( { $< [MonthYear] = { $(=addmonths(MonthYear),-1) }

>} Total )

MonthYear It´s a Date.

But it´s returning 0s.

What is wrong ?

Thanks.

[Dalton_Ruer]

The expression editor will show you at the bottom of the screen what the expression evaluates to so that you can see what happens with your formulas like that. What does it show you?

[Pdmotta]

Thanks Dalton :

Something like
SUM( { $< [MonthYear] = {} >} Total )
it´s seaming that does not evaluate
date calculation...

I´m trying the Modifier /Difference

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Measures/modifiers.htm

[Dalton_Ruer]

Not sure what datatype your month year field is. but it looks from what your showing like the -1 is outside the AddMonths function. Should be: AddMonths(MonthYear, -1)

[Pdmotta]

Change to

SUM( { $< [MonthYear] = { $(=addmonths(MonthYear,-1)) }

>} Total )

returns zero and the resume show don´t evaluate de addmonths too

I believe it´s quite simple but I can´t get it.