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: 
robertsb41
Contributor III
Contributor III

Set Analysis Will Not Work when trying to Using Another Field

sum({< ABC_Bid_Amount={"<Low_Comp_Bid"}>} ABC_Bid_Amount)

 

My expression works great if I replace Low_Comp_Bid with a value like 1000000.  It always returns 0 if I use any other field and not a value.  What am I missing?

Thanks!

Labels (1)
1 Solution

Accepted Solutions
Taoufiq_Zarra

Maye be :

=sum({<ABC_Bid_Amount={"=ABC_Bid_Amount<Low_Comp_Bid"}>} ABC_Bid_Amount)

If i understood correctly the request

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

3 Replies
Taoufiq_Zarra

Maye be :

=sum({<ABC_Bid_Amount={"=ABC_Bid_Amount<Low_Comp_Bid"}>} ABC_Bid_Amount)

If i understood correctly the request

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
wayne-a
Creator
Creator

robertsb41
Contributor III
Contributor III
Author

Thank you!