# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Creator III

## Set Analysis with Greater than Amount

Hi,

Based on what I found online I believe the following formula should work but it doesn't. Any Suggestions?

Sum({\$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {">= 5000"}>} OSAmt)

Thanks!

1 Solution

Accepted Solutions
MVP

HI

Try like below

Sum({\$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, urPrimaryKeyField= {"=Sum(OSAmt)>= 5000"}>} OSAmt)

Thanks & Regards,
Mayil Vahanan R
11 Replies
Specialist

@greend21 Try with single quotes.

Sum({\$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {'>= 5000'}>} OSAmt)

OR
Sum({\$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {'=SUM(OSAmt)>= 5000'}>} OSAmt)

Creator III
Author

Unfortunately that doesn't work either.

Specialist II

What are you trying to do, what is "not working"

Creator III
Author
It makes it so that no values return and there are items over 5000. I've even done it with smaller numbers like 10.
Specialist II

OSAmt = {">= 5000"} is going to limit at the row level for each OSAmt.  Are there records in the data model that are >5000 or is it the sum of OSAmt you need greating then 5000.

Creator III
Author
Yes, there are records over 5000. I tested it with smaller numbers too just to be save and it still did not work. I want it to sum only those over the amount, so row level is fine.
Specialist II

Your expression does look fine.  And i assume there are records >=5000 AND SuretyOver90Ind=1 AND RecvOpenStatus= 'Open'?

1) Are you sure OSAmt a numeric type field?  I suppose it is if your sum expression works without the >=5000 filter.

2) Are you seeing any syntax issues in the editor?

Sum({\$<RecvOpenStatus = {'Open'}, SuretyOver90Ind = {1}, OSAmt = {">= 5000"}>} OSAmt)

Creator III
Author
Yes, the sum works otherwise and it is a field I use in other tables with no issues, so it is definitely a number. There are no errors in the syntax editor.
Specialist II

Ok, unfortunately I don't know of any other reason it's not working.  Can you share a sample data set with the issue?

Tags
Community Browser