Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Pdmotta
Contributor III
Contributor III

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

AcountMonthYearTotalPreviuos Month
Assetfeb 202112345.6710030.00
Cashfeb 202123456.7820999.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)
4 Replies
Dalton_Ruer
Support
Support

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
Contributor III
Contributor III
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

Dalton_Ruer
Support
Support

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
Contributor III
Contributor III
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.