Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

0 Replies