Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lomi89
Contributor III
Contributor III

Acumulative costs by months Set analysis

Hello, I would like to create an acumulative field with cost on Set Analysis. I have to aggregate the cost by date and this date is filtered:

months: =DATE(IF(DATE1>=AddMonths(monthstart(today()),-12) and DATE1<= AddMonths(today(),-1), MONTHSTART(DATE1)),'MM-YY')

Cost:  =rangesum(above(MT_COUT_SHAM,0, MONTHSTART(DATE1)))

 

Whith this formulas I can't do it:

lomi89_0-1642612702846.png

Thank you very much

 

Labels (1)
1 Solution

Accepted Solutions
anat
Master
Master

rangesum(above(sum(MT_COUT_SHAM),0,12))

View solution in original post

1 Reply
anat
Master
Master

rangesum(above(sum(MT_COUT_SHAM),0,12))