Qlik Community

Ask a Question

New to Qlik Sense

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

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 

State role playing dimension - Just one filter

Hi all,

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.

Any help will be appreciated! Thank you!

Labels (1)
0 Replies