topic Re: Set Analysis Will Not Work when trying to Using Another Field in App Development

Set Analysis Will Not Work when trying to Using Another Field

robertsb41 — Wed, 22 Dec 2021 17:26:36 GMT

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!

Re: Set Analysis Will Not Work when trying to Using Another Field

Taoufiq_Zarra — Thu, 02 Jul 2020 14:33:24 GMT

Maye be :

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

If i understood correctly the request

Re: Set Analysis Will Not Work when trying to Using Another Field

wayne-a — Thu, 02 Jul 2020 15:27:38 GMT

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-selection/td-p/639724

Re: Set Analysis Will Not Work when trying to Using Another Field

robertsb41 — Thu, 02 Jul 2020 19:32:56 GMT

Thank you!