Set Analysis Will Not Work when trying to Using Another Field

[robertsb41]

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!

[Taoufiq_Zarra · Accepted solution]

Maye be :

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

If i understood correctly the request

[wayne-a]

See this community post, it uses a somewhat obscure function. 

https://community.qlik.com/t5/New-to-QlikView/Set-Analysis-Setting-a-field-equal-to-another-field-s-...

[robertsb41]

Thank you!