Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
asmithids
Partner
Partner

Set Analysis - Previous Dates

Hello,

I have a fairly simple set expression where I need to sum all payment amounts prior to the current month. I have the following expression to do that but, I'm not getting any data.  When I remove the "less than sign" from the month set, I get numbers.  Cleary, the "less than sign" on the month set is the problem but, I don't know why. 


Has anyone solved this problem?  I've checked the Community and see that what I have scripted seems to be correct but, it's not working. 

Sum({$<Year={$(=Max(Year))}, Month=“<$(=Month(Today()))"}>}PaymentAmount)

Thank you in advance for any help!! 

1 Solution

Accepted Solutions
achettipalli
Creator
Creator

Hi Alec,

This returns the sum of all payments of the recent year prior to current month.

=sum({$<Year={"$(=Max(Year))"},Month={"<$(=Max(month(today())))"}>}PaymentAmount)

good luck!

Avinash

View solution in original post

3 Replies
achettipalli
Creator
Creator

Hi Alec,

This returns the sum of all payments of the recent year prior to current month.

=sum({$<Year={"$(=Max(Year))"},Month={"<$(=Max(month(today())))"}>}PaymentAmount)

good luck!

Avinash

View solution in original post

asmithids
Partner
Partner
Author

That worked!  Thanks Avinash!

achettipalli
Creator
Creator

Glad it helped.

Cheers!