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

Previous Month

Hi All ,

How do i include this expression in previous month set anakysis ?

RangeSum(Above(TOTAL Sum(open) - sum(Close), 0, NoOfRows(TOTAL)))...

iam trying to include in this way is this correct ..as shown below

=RangeSum(Above(TOTAL Sum(Open) - sum(Close), 0, NoOfRows(TOTAL)),month(addmonths(max(Date), - 1)) )

Thanks in advance....

1 Reply
olivetwist
Creator
Creator

That isn't a set analysis format. Have you looked at any guides like this Set Analysis: syntaxes, examples