# App Development

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for
Did you mean:
Contributor II

## Set Analysis Table Previuos Month

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.

Labels (1)
• ### Other

4 Replies
Employee

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?

Contributor II
Author

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

Employee

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)

Contributor II
Author

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.

Tags
Community Browser