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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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
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.