Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
JASalinas
Creator
Creator

Montly Accumulation

Hi my friend...  I have the next expression on the chart table:

=(sum({<[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod)"}, [MonthNumPeriod] = {">= {'1'} <=$(=max(MonthNumPeriod))"}, [MonthPeriod]=>}[AMOUNT]*-1)) +
(sum({<[ACCNT_CODE]={"8*","9*"}, [FUND]=-{"30*"}, [YearPeriod] = {"$(=YearPeriod-1)"}, [MonthNumPeriod] = {">=$(=max(MonthNumPeriod)+1)"}, [MonthPeriod]=>}[AMOUNT]*-1)) 

JASalinas_0-1628701710370.png

Buy I want the sum of the totals to be monthly for Exemplo:

07-2021 = 28,119,839.16, 06-2021 = 27,362,361.27, 05-2021 = 26,308,362.23 etc...

The data is in a database sql server.

 

 

0 Replies