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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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....

Labels (1)
1 Reply
olivetwist
Creator
Creator

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