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.