Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
greend21
Creator III
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
MayilVahanan

HI 

Try like below

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

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

11 Replies
Qlik1_User1
Specialist
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)

greend21
Creator III
Creator III
Author

Unfortunately that doesn't work either.

stevejoyce
Specialist II
Specialist II

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

greend21
Creator III
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.
stevejoyce
Specialist II
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.

greend21
Creator III
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.
stevejoyce
Specialist II
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)

greend21
Creator III
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.
stevejoyce
Specialist II
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?