Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
MVP

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

-Rob

MayilVahanan
MVP
MVP

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.