Complex Application

nigharikkha — Thu, 03 Feb 2022 10:02:40 GMT

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.

Please help in this.

Thanks in advance.

topic Complex Application in QlikView

Complex Application