Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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
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
achettipalli
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
Partner

Re: Set Analysis - Previous Dates

That worked!  Thanks Avinash!

Highlighted
achettipalli
Contributor

Re: Set Analysis - Previous Dates

Glad it helped.

Cheers!