Max 1 selection in some sheets

[CasperQlik]

Hi Qlik Community

I have an app with multiple sheets.

All sheets have the option to select values in the year field. But on a select few sheets I need to restrict the user so that charts can only show 1 year at a time on those select sheets. I hope the issue is clear.

So far I have tried creating a separate "Year" field and combining it with alternate states works fine for those sheets that needs to behave differently. However, when I use the option to restrict that new year field to "Always one selected value" then the app just acts weird in my opinion. I get this box at the top with all my possible states and I don't understand how to proceed from here. Any help is appreciated and alternative solutions are welcome too.

[marcus_sommer · Accepted solution]

I think I wouldn't go with such approaches else restricting the expressions within the charts to the selection state, maybe like:

sum({< Year = {"$(=max(Year))"}>} Value)

and adjusting the user-documentation that always the max. Year is taken - in regard to all years respectively the selected ones.

[CasperQlik]

This does work to some extent. I just need to make it clear what the user is seeing. I'll run it by the users.

[CasperQlik]

Is it possible to make it the latest selection and not the max()?

[marcus_sommer]

Yes, maybe with something like: 

sum({$1< Year = {"$(=max(Year))"}>} Value)

or

sum({< Year = {"$(=max({$1} Year))"}>} Value)