Alternate States

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have an app with the following objects (it has Alternate States):

Then I have the following expressions for the chart:

1 - SUM({[GROUP_1]<MATERIAL={'05'}}>}SALES)

2 - SUM({[GROUP_2]<MATERIAL={'05'}}>}SALES)

With the Dimension = Period (MMM-YY)

What I need is that if I select a Year from the listbox, for example, 2015, it should show me Jan-15 to Dec-15 in the chart.

As the Listbox for Year has an Alternate State = Inherited,

And the Multiple Selection Box 1 for Group 1 has Alternate State = Group 1

And the Multiple Selection Box 1 for Group 2 has Alternate State = Group 2

The Year selection doesn't reflect the value in the chart. Is there any way to do that?

Thank you!!!

Re: Alternate States

CarlosAMonroy — Mon, 18 Dec 2017 21:56:40 GMT

Hi,

You can try the following expression:

1 - SUM({[GROUP_1]<Year = $:: Year, MATERIAL={'05'}}>}SALES)

2 - SUM({[GROUP_2]<Year = $:: Year, MATERIAL={'05'}}>}SALES)

If that does not work, would be great if you can share a sample app.

Carlos