Need help in creating an application with QlikView with following requirement.
I have 4 tables in the data source with following fields.
Table#1 - TestControl
ControlKey:
Test:
Plane:
Slot:
Count:
ID:
Location:
Table#2 - Programs
ProgramKey:
TestType:
Table#3 - Data
DataKey:
Device:
Fail:
Table#4 - Keys
ControlKey:
ProgramKey:
DataKey:
I have to perform the following algorithm on a button click.
The user has to select Test, Plane, Slot, ID and Location from table#1. Based on the selection, filter and get the Count and ControlKey values. Use these ControlKeys values to get corresponding ProgramKey values from table#4. From using this list of ProgramKey, filter the ProgramKey from table#2, which are of specific TestType value. Again from the table#4, using this filtered ProgramKey, get the DataKey values. Atlast from the table#3, use the DataKey to get corresponding Device and Fail values. Find the number of Devices which has Fail as 1.
