Help me with problem where i can trigger the selection alternate state for single calender. Where i can switch the selection of calender from state A to state B. So that i will get desired result in chart expression.
If requires, can explain further. Attached the QVW for workout.
My business user want selection for date range and also on month basis. But problem with single calender is that is i select month basis then it select that month and year so all dates wont be available in date range selection. So i want to use alternate state so that i can use both selection for single chart expression. Copy stae content and swap state contents will not do the purpose. If you have any other way to solve problem your welcome.
Did you try using set analysis in your expression? I mean you can ignore the selected month (Month=) and then play around with the whole data set available.
When you use Month= and Year= in the set analysis expression, this helps us ignore the selection and further helps us to play around with whole data set. Also you can try using TOTAL qualifier in set analysis.
