Multiple mandatory filter selection not changing values.

[ashishp]

Hi There 

I have 2 mandatory filters in Qlik Sense report, 

However not able to select or change values from filters if we have more than 1 mandatory filters. 

I have use option (Always One selected value) 

Any possible solution for this issue? 

Thanks for your help. 

[edwin]

this may be an issue with the associations - maybe it is possible that for the filtered values in one field, there are no selectable values in the other. 

what i suggest is that you temporarily remove the always one selected in both fields and apply the filter in one field and see what are selectable in the other.

[Mark_Little]

Sorry i don't think there is a way to do it, not the same as always one selected.

I would either have a default bookmark and train the users they must them selected or add to the set analysis on all charts and tables.

[Or]

Always One Selected means just that - there must always be one selected value for this field. Note that if one of these filters results in values of the other filter being excluded, you won't be able to select those values.

If you're looking for e.g. fields "Date" and "BusinessUnit" must have one or more selected values to view data, consider using calculation conditions within your individual objects to prevent them from calculating until a selection has been made on the required fields. For example,

GetSelectedCount(Date) > 0 AND GetSelectedCount(BusinessUnit) > 0

This approach would also work around the issue of mutual exclusion in two required filters as there is no issue selecting the excluded values while overriding the other required filter - you just won't get a result until you re-apply a selection to the second filter.