Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alenb
Partner
Partner

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.

0 Replies