# Qlik Sense App Development

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!!

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Contributor

## Re: Set Analysis - Previous Dates

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

3 Replies
Highlighted
Contributor

## Re: Set Analysis - Previous Dates

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

Partner

## Re: Set Analysis - Previous Dates

That worked!  Thanks Avinash!

Contributor