Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?


1 Reply
Not applicable

Hi Daniel,

By using Joins U wil b get wat u want.

Warm Regards,