topic Re: Variable output into chart in App Development

Variable output into chart

MrAndrews — Sat, 16 Nov 2024 05:26:14 GMT

I have an app where I want a value to be dynamic based on a user choice, which is all ok. However, they also want the choice 'title' to be shown in the table.

So the user chooses 'GWP', they see a value form GWP, and the word GWP in a different column. I dont seem to be able to get it to change! The value is dynamic, but not the string. Mock up attached.

Re: Variable output into chart

Lisa_P — Tue, 02 Jul 2019 02:08:22 GMT

What do you need to see in the table and where do you need to see it ?

Re: Variable output into chart

MrAndrews — Tue, 02 Jul 2019 08:35:23 GMT

Hi Lisa - In the column 'DriverDetailDesc' it should be the chosen option driver by the buttons above.

If the driver name is Prem - it would be GWP or NWP. If the Driver Name is Claims it would be either NIC or Attr.

At the moment I can't get the literal to update in the DriverDetailDesc column, despite it updating the actual value in 'DriverValue'

Cheers!

Re: Variable output into chart

Lisa_P — Tue, 02 Jul 2019 23:00:45 GMT

Ok got it. Change your expression in the DriverDetailDesc field to:

=if(DriverName = 'Prem', '$(vPremDriver)' , '$(vClaimDriver)' )

Re: Variable output into chart

MrAndrews — Wed, 03 Jul 2019 07:16:28 GMT

Ah mega! I really need to brush up on my dollar expansion. I get super mixed up with when to and how to use. Cheers!