I'm new to QlikSense and I have a problem that I don't know how to figure out.
I have three dimensions, State , Customer and Warehouse. Each Customer belongs to a certain State as well as each Warehouse and I need to show sales amount by customer from a State, regardless the warehouse from where the products where dispatched (it can be sent from different warehouses, not only being the ones in that same state).
The thing is that as soon as I filter by state, only the warehouses of that selected state appear.
I dont know if I have to model something like a role playing dimension (eg: State-Customer, State-Warehouse) but that would imply using more than just one filter for my dashboard and I would like to avoid that, as I only have to model the specific behaviour on a specific table.