topic Re: Programmatically change alternate state values in App Development

Programmatically change alternate state values

HDbrpJA8E4 — Fri, 22 Jan 2021 07:51:43 GMT

Hi,

I have an app where the user chooses an machine and a year from an filter pane and i show him different performance values.

i have one diagram where i show him the data per calendar week and one where the whole year is summarised.

Now i want to add another diagram where i show him the summarised values for the last year.

What i did was to create an alternate state and that would work fine. Problem is usability.

If an user selects a year, i want to automatically change the value in the alternate state to the last year.
If a user selects a machine, it should do so also in the alternate_state.
- i would have the possibility to only work with the default state, but not when the field has the property "Always one selected value"
  - I still could only work with the default state, but it gets so confusing in the filter.

Is there a way to programmatically change the values in the alternate state when the values change in the default state?

Or is there another way simpler solution?

Thanks

Re: Programmatically change alternate state values

edwin — Sun, 24 Jan 2021 20:27:21 GMT

you dont need alternating states for this, you can use set analysis:

{<... YEAR={$(=only(YEAR)-1)}...>}

Re: Programmatically change alternate state values

HDbrpJA8E4 — Mon, 25 Jan 2021 08:27:23 GMT

Hi thanks, got it.
But now i have another issue.

I did define my Measures, with colours and everything, like this:

(sum(made_pieces)/sum(productive_duration_sec))*3600

But now i need another measure for the previous year:

(sum({<booking_isoyear={$(=booking_isoyear-1)}>}made_pieces)/sum({<booking_isoyear={$(=booking_isoyear-1)}>}productive_duration_sec))*3600

Do i have another option than to define every Measure twice?

Re: Programmatically change alternate state values

jyothish8807 — Mon, 25 Jan 2021 09:09:58 GMT

You will have to modify all the expressions where you want to show last year value. Better would be you create a variable and use that is all your expression, so next time if you want to change from last year to previous 2 year , you can simply achieve that by modifying the variable. Like this:

vPreviousYear = Year(Max(booking_isoyear))-1

(sum({<booking_isoyear={$(vPreviousYear )}>}made_pieces)/sum({<booking_isoyear = {$(vPreviousYear)}>}productive_duration_sec))*3600

Re: Programmatically change alternate state values

HDbrpJA8E4 — Tue, 26 Jan 2021 07:11:50 GMT

Hi,

thanks for your answer. I made it as you said and everything is working fine. However, i do not really like this solution as i have to define the same Measure twice.

I do still think working with alternate states would be the cleanest solution, if it would be possible to trigger an change somehow.

I keep it open in the meantime, maybe someone else comes up with a different solution.

Best Regards

Re: Programmatically change alternate state values

edwin — Tue, 26 Jan 2021 14:46:55 GMT

if you want to use alt states, you can specify the state when you are adding your triggers. you first define your alt state in doc settings, then in field triggers: