topic Re: Set Analysis Table Previuos Month in App Development

Set Analysis Table Previuos Month

Pdmotta — Tue, 21 Dec 2021 21:56:36 GMT

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.

Re: Set Analysis Table Previuos Month

Dalton_Ruer — Tue, 27 Apr 2021 18:41:19 GMT

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?

Re: Set Analysis Table Previuos Month

Pdmotta — Tue, 27 Apr 2021 18:54:24 GMT

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

Re: Set Analysis Table Previuos Month

Dalton_Ruer — Wed, 28 Apr 2021 13:27:19 GMT

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)

Re: Set Analysis Table Previuos Month

Pdmotta — Wed, 28 Apr 2021 21:12:49 GMT

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.