Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Retrieve data from different rows using QVD based on condition

I am trying to pull data from QVD file for the below conditions and populate the data in List box.

If IDENTIFIER = "BSA DRY RUN" populate rows for BSA DRY RUN, REGION  and CONSENT

If IDENTIFIER = "NBN DRY RUN" populate rows for NBN DRY RUN, ADDRESS and CONSENT

QVD file has the below data format, column names (ie, IDENTIFIER, ItemA, ItemB)

IDENTIFIER         ItemA                                      ItemB

BSA DRY RUN     BSA DRY RUN REPORT:     THIS REPORT HELPS BUSINESS USERS

NBN DRY RUN     NBN DRY RUN REPORT:     THIS REPORT HELPS END USERS

REGION                      REGION.REGIONID             REGION ID OF THE CUSTOMER

REGION                      REGION.REGION_NAME      NAME OF THE REGION

ADDRESS                      ADDRESS.PAYLOAD_ID          CLIENT UNIQUE ID

ADDRESS                  ADDRESS.BATCH_ID                BATCH ID

CONSENT                  CONSENT.CIDN                 CUSTOMER ID

CONSENT                      CONSENT.CIDN_DESCRIPTION      CIDN DESCRPTION

COULD SOMEONE PLEASE LET ME KNOW HOW TO DO THIS?

Community Browser