Dear friends, I´ve got a problem that hopefully you can help me with. I try to solve it using alternate states, don´t know if there´s any other way, but this felt like the correct way to do it.
I´ve attached a qvw, with a very simple P/L statement. I´ve got a chart (pivot table) with columns for different versions and years. I use SET analysis to define what year that should be presented in each column. All the different versions contain Values for only the year that they were created (field VersionCreationYear), except for the MTP that contains values for the next three years after the year it was created. Let´s say for example that I want so select Year=2017, and then I want to display the MTP (field Version) that was created in 2016. That MTP contains the years 2017 - 2019. Now, the list boxes wouldn´t behave the way I want. If I select VersionCreationYear 2016 and Year 2017 that would make me unable to select for example 'Forecast1' in the Version field (I have one column that displays the highest selected Forecast nr).
I thought I could solve this with Alternate states, but I get some problems that I´m not able to solve
- I still want to be able to make selections in all other fields in the database, and they should be reflected in all columns (in my real app there are a lot of other fields).
- I want it to be mandatory to select one value in the field VersionCreationYear, since I don´t want the MTP columns to display values from many MTP Versions on the same year. The chart should only be calculated when on VersionCreationYear is selected.
Does anyone have a solution?
Regards Johan
