Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Pdmotta
Contributor II
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

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)
  • Other

4 Replies
Dalton_Ruer
Employee
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?

 

Pdmotta
Contributor II
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

Dalton_Ruer
Employee
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)

Pdmotta
Contributor II
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.