How to filter the filed that is "Always one selected value"
My model is as follows.
MARKET: Load MKey, MName Inline [ MKey, MName OC, Oceania AS, Asia EU, Europe ];
REPORT: // RName is set as 'Always one selected value' Load MKey, RName Inline [ MKey, RName OC, Report1 OC, Report2 OC, Report3 AS, Report4 EU, Report5 ];
In the sheet editor I have set the RName field to be "Always one selected value", because I want the user to only be able to select one at the time.
But I also want the user to be able to pre-select (filter) the REPORTs based on selected MARKET. This doesn't work as intended because the REPORT always has one default value selected, and that reverse-filters the MARKET table, making the other selections impossible to make.
I tried the following approach but it also does not work. I un-related the two tables, and used the dimension expression.
Instead of RName in the filter pane, I entered this:
=if(MKey = MarketKey, RName)
And loaded the data like this:
REPORT: // Set as 'Always one selected value' Load MKey as MarketKey, RName Inline [ MKey, RName OC, Report1 OC, Report2 OC, Report3 AS, Report4 EU, Report5 ];
Any ideas? It seems like a pretty logical thing to do to simply filter the field that can only have one selection, but I just can't find a way in QlikSense.
