Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

wolfgangmohr
New Contributor II

AND versus OR

Hi Folks,

AND versus OR means:

I have two Dimension tables and one fact table.

DimCustomer:     &customerid, customername, zip, city

DimDepartment:  &departmentId, departmentname, room, floor,

FactOrders:         &customerid, &departmentid, orderid, number, amount, etc1,

When choosing one Department, this will show the Customer who is linked to it.

When choosing two Departments, this will show all Customers which are linked either to the one or to the other Department.

How can I manage to show only These Customers with orders linked to BOTH selected Departments?

I hope my question is understood and look Forward to some Feedback,

for which I like to give you all of my Thanks beforehand!

Wolfgang, AmateuerQliker

Tags (1)
1 Solution

Accepted Solutions

Re: AND versus OR

See these blog posts:

AND-Mode

AND and OR


talk is cheap, supply exceeds demand
1 Reply

Re: AND versus OR

See these blog posts:

AND-Mode

AND and OR


talk is cheap, supply exceeds demand
Community Browser