Overlapping filter logic (Multi-level Categorization and View Filtering)

Question & Answer
, , ,
1

Hi I am struggling to apply a filter logic for a column with overlapping values.

This is my current logic:
ifelse(IN({is_amzl_juris}, [‘AMZL Coverage’,‘RSR Coverage’,‘Non-Amazon Coverage’]), ‘3.0 View’,
ifelse(IN({is_amzl_juris}, [‘AMZL Coverage’]) ), ‘2.0 View’,“”,
))

When I try this approach and I select the filter of “3.0 View” I successfully get all results wished ( amzl coverage, rsr and non-amazon’, HOWEVER, when I select 2.0 on my filter I don’t get any data when in fact I wish to get “AMZL Coverage”

Can you please advice?

2

Hello @Jose_Prego , welcome to the QuickSight community!

First, I would double check that the way that you have written 2.0 View is the same in both your calculated field and your filter.

3

Thanks @duncan. I was able to resolve the issue by creating two calculated fields, one containing 2.0 scope and another for 3.0 scope. I then proceeded to create another calculated field that calls the parameter $View.

ifelse(${View} = ‘2.0 View’, {2.0 Calculated Field},
ifelse(${View} = ‘3.0 View’, {3.0 Calculated Field}, ‘’
)

1 Like