Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-12-15 04:18 AM

All Data filter

I have 3 tables:

Building --< Material --- InStock

--< One-to-many; --- one-to-one

Building: BuildingID

Material: BuildingID, MaterialID

InStock: MaterialID, InStock

Selecting InStock='Yes' filters to Buildings that have any number of Materials in stock. How do I show only Buildings where ALL materials needed for that building are in stock?

Any ideas?

Daniel

2,477 Views
0 Likes
1 Reply
Not applicable
‎2010-12-15 04:21 AM
Author

Hi Daniel,

By using Joins U wil b get wat u want.

Warm Regards,

Sri

105 Views
0 Likes