topic Retrieve data from different rows using QVD based on condition in QlikView https://community.qlik.com/t5/QlikView/Retrieve-data-from-different-rows-using-QVD-based-on-condition/m-p/487800#M692934 <HTML><HEAD></HEAD><BODY><P></P><P>I am trying to pull data from QVD file for the below conditions and populate the data in List box.</P><P></P><P></P><P></P><P>If IDENTIFIER = "BSA DRY RUN" populate rows for BSA DRY RUN, REGION&nbsp; and CONSENT</P><P></P><P></P><P>If IDENTIFIER = "NBN DRY RUN" populate rows for NBN DRY RUN, ADDRESS and CONSENT</P><P></P><P></P><P></P><P>QVD file has the below data format, column names (ie, IDENTIFIER, ItemA, ItemB)</P><P></P><P></P><P></P><P>IDENTIFIER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ItemA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemB</P><P></P><P></P><P>BSA DRY RUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BSA DRY RUN REPORT:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;THIS REPORT HELPS BUSINESS USERS</P><P></P><P></P><P>NBN DRY RUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NBN DRY RUN REPORT:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;THIS REPORT HELPS END USERS</P><P></P><P></P><P>REGION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGION.REGIONID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGION ID OF THE CUSTOMER</P><P></P><P></P><P>REGION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGION.REGION_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME OF THE REGION</P><P></P><P></P><P>ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADDRESS.PAYLOAD_ID&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CLIENT UNIQUE ID</P><P></P><P></P><P>ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADDRESS.BATCH_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BATCH ID</P><P></P><P></P><P>CONSENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONSENT.CIDN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CUSTOMER ID</P><P></P><P></P><P>CONSENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONSENT.CIDN_DESCRIPTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CIDN DESCRPTION</P><P></P><P></P><P></P><P></P><P>COULD SOMEONE PLEASE LET ME KNOW HOW TO DO THIS?</P></BODY></HTML> Tue, 13 Aug 2013 08:23:09 GMT 2013-08-13T08:23:09Z Retrieve data from different rows using QVD based on condition https://community.qlik.com/t5/QlikView/Retrieve-data-from-different-rows-using-QVD-based-on-condition/m-p/487800#M692934 <HTML><HEAD></HEAD><BODY><P></P><P>I am trying to pull data from QVD file for the below conditions and populate the data in List box.</P><P></P><P></P><P></P><P>If IDENTIFIER = "BSA DRY RUN" populate rows for BSA DRY RUN, REGION&nbsp; and CONSENT</P><P></P><P></P><P>If IDENTIFIER = "NBN DRY RUN" populate rows for NBN DRY RUN, ADDRESS and CONSENT</P><P></P><P></P><P></P><P>QVD file has the below data format, column names (ie, IDENTIFIER, ItemA, ItemB)</P><P></P><P></P><P></P><P>IDENTIFIER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;ItemA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemB</P><P></P><P></P><P>BSA DRY RUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BSA DRY RUN REPORT:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;THIS REPORT HELPS BUSINESS USERS</P><P></P><P></P><P>NBN DRY RUN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NBN DRY RUN REPORT:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;THIS REPORT HELPS END USERS</P><P></P><P></P><P>REGION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGION.REGIONID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGION ID OF THE CUSTOMER</P><P></P><P></P><P>REGION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; REGION.REGION_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME OF THE REGION</P><P></P><P></P><P>ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADDRESS.PAYLOAD_ID&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CLIENT UNIQUE ID</P><P></P><P></P><P>ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ADDRESS.BATCH_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BATCH ID</P><P></P><P></P><P>CONSENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONSENT.CIDN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CUSTOMER ID</P><P></P><P></P><P>CONSENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CONSENT.CIDN_DESCRIPTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CIDN DESCRPTION</P><P></P><P></P><P></P><P></P><P>COULD SOMEONE PLEASE LET ME KNOW HOW TO DO THIS?</P></BODY></HTML> Tue, 13 Aug 2013 08:23:09 GMT https://community.qlik.com/t5/QlikView/Retrieve-data-from-different-rows-using-QVD-based-on-condition/m-p/487800#M692934 2013-08-13T08:23:09Z