Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!

11 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you test this by manually making selections that match the set?  

-Rob

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.