topic Re: Set Expression based on variable not working in App Development

Set Expression based on variable not working

julietotsch — Thu, 23 Dec 2021 18:28:44 GMT

I have multiple buttons. When one of them is clicked, it will set a variable - vHospitalSystem - to a value. I, then, want to use that value to select a column from a table and bring back that value:

HospitalSystem	Target1	Target2
ABCM	25	35
DEFN	20	23

My expression is:

= sum({$<[HospitalSystem] = ${vHospitalSystem} >}[Target1])

I have checked that the variable is set to the correct Hospital System (ABCM). I do not understand why it is bringing back 0 and not 25.

Re: Set Expression based on variable not working

RsQK — Fri, 17 Dec 2021 06:38:27 GMT

Hi, it's the syntax. Should look like this:

SUM({$<[HospitalSystem]={'$(vHospitalSystem)'}>}[Target1])

Re: Set Expression based on variable not working

anat — Fri, 17 Dec 2021 07:28:07 GMT

What is the expression of vHospitalSystem?