Our BI Team did an ETL process with the ETQ data - in a data warehouse then made available to Qlik. Next create a view in ETQ Designer mode with the desired columns. After the view is generated, go to the properties tab then open the link for the data source copy the SQL Selection Statements then paste into the load editor. You will want to do some cleanup and renaming of columns in the load editor....for example take this
SELECT
AUDIT_CAR_MAIN_FORM.AUDI_CA_MAIN_FORM_ID AUDI_CA_MAIN_FORM_ID,
PHASE_SETTINGS.DISPLAY_NAME PHASE_SETTINGS_DISPLAY_NAME,
MER_SM_PLANT_PROFILE_1.MER_SM_PLANT_PLANT M_S_PLA_PROFI_1_ME_S_PLAN_PLAN,
AUDIT_CAR_MAIN_FORM.ETQ$NUMBER AUDIT_CAR_MAIN_FORM_ETQ$NUMBER,
BOOLEAN_VALUES_2.DESCRIPTION BOOLEAN_VALUES_2_DESCRIPTION,
AUDIT_CAR_MAIN_FORM.ETQ$DUE_DATE AUDI_CA_MAIN_FORM_ETQ$DUE_DATE,
USER_SETTINGS_3.DISPLAY_NAME USER_SETTINGS_3_DISPLAY_NAME,
IA_AUDIT_TYPE_1.DESCRIPTION IA_AUDIT_TYPE_1_DESCRIPTION,
QMS_TYPE_1.DESCRIPTION QMS_TYPE_1_DESCRIPTION,
AUDIT_CAR_MAIN_FORM.AUDIT_STARTED AUDI_CA_MAI_FORM_AUDIT_STARTED,
AUDIT_CAR_MAIN_FORM.AUDIT_ENDED AUDI_CAR_MAIN_FORM_AUDIT_ENDED,
NC_CLASSIFICATION_1.DESCRIPTION N_CLASSIFICATION_1_DESCRIPTION,
USER_SETTINGS_4.DISPLAY_NAME USER_SETTINGS_4_DISPLAY_NAME,
AUDIT_CAR_MAIN_FORM.CAR_DATE_INITIATED AUD_CA_MAI_FOR_CA_DAT_INITIATE,
AUDIT_CAR_MAIN_FORM.AUDIT_NUMBER AUDI_CA_MAIN_FORM_AUDIT_NUMBER,
Convert to
SELECT
AUDIT_CAR_MAIN_FORM.AUDI_CA_MAIN_FORM_ID AS [Findings DB ID],
PHASE_SETTINGS.DISPLAY_NAME AS [PHASE NAME],
MER_SM_PLANT_PROFILE_1.MER_SM_PLANT_PLANT AS [Plant],
AUDIT_CAR_MAIN_FORM.ETQ$NUMBER AS [Findings Number],
BOOLEAN_VALUES_2.DESCRIPTION AS [Repeat Issue?],
AUDIT_CAR_MAIN_FORM.ETQ$DUE_DATE AS [DUE DATE],
USER_SETTINGS_3.DISPLAY_NAME AS [Initator Name],
IA_AUDIT_TYPE_1.DESCRIPTION AS [AUDIT_TYPE],
QMS_TYPE_1.DESCRIPTION AS [QMS_TYPE_1_DESCRIPTION],
AUDIT_CAR_MAIN_FORM.AUDIT_STARTED AS [AUDIT START Date],
AUDIT_CAR_MAIN_FORM.AUDIT_ENDED AS [AUDIT End Date],
NC_CLASSIFICATION_1.DESCRIPTION AS [CLASSIFICATION DESC],
USER_SETTINGS_4.DISPLAY_NAME AS [USER_SETTINGS_4_DISPLAY_NAME],
AUDIT_CAR_MAIN_FORM.CAR_DATE_INITIATED AS [DATE INITIATE],
AUDIT_CAR_MAIN_FORM.AUDIT_NUMBER AS [AUDIT NUMBER],
DEPARTMENT_1.DEPARTMENT_NAME AS [DEPARTMENT NAME],
PROCESS_AREAS_1.DESCRIPTION AS [PROCESS AREAS],
ISO_ELEMENTS_1.ISO_ELEMENTS_NAME AS [ISO ELEMENTS NAME]
