Skip to main content

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 
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

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