topic Referencing fields from two different QVDs in QlikView https://community.qlik.com/t5/QlikView/Referencing-fields-from-two-different-QVDs/m-p/1291358#M403721 <HTML><HEAD></HEAD><BODY><P>I have 2 QVDs</P><P></P><P>AMERICA:</P><P>Load</P><P>Salesperson </P><P>from America.qvd</P><P></P><P></P><P>CANADA:</P><P style="font-size: 13.3333px;">Load </P><P style="font-size: 13.3333px;">Product </P><P style="font-size: 13.3333px;">from Canada.qvd</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">What I need to do is write an if statement ie </P><P style="font-size: 13.3333px;">If (Salesperson like 'Smith' and Product like 'Steel*, 'Outsourced') as Outsourced_items </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">however as you can see my fields are coming from two different fields. Is there a simple way to do this ? </P></BODY></HTML> Thu, 16 Feb 2017 15:33:51 GMT 2017-02-16T15:33:51Z Referencing fields from two different QVDs https://community.qlik.com/t5/QlikView/Referencing-fields-from-two-different-QVDs/m-p/1291358#M403721 <HTML><HEAD></HEAD><BODY><P>I have 2 QVDs</P><P></P><P>AMERICA:</P><P>Load</P><P>Salesperson </P><P>from America.qvd</P><P></P><P></P><P>CANADA:</P><P style="font-size: 13.3333px;">Load </P><P style="font-size: 13.3333px;">Product </P><P style="font-size: 13.3333px;">from Canada.qvd</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">What I need to do is write an if statement ie </P><P style="font-size: 13.3333px;">If (Salesperson like 'Smith' and Product like 'Steel*, 'Outsourced') as Outsourced_items </P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">however as you can see my fields are coming from two different fields. Is there a simple way to do this ? </P></BODY></HTML> Thu, 16 Feb 2017 15:33:51 GMT https://community.qlik.com/t5/QlikView/Referencing-fields-from-two-different-QVDs/m-p/1291358#M403721 2017-02-16T15:33:51Z Re: Referencing fields from two different QVDs https://community.qlik.com/t5/QlikView/Referencing-fields-from-two-different-QVDs/m-p/1291359#M403722 <HTML><HEAD></HEAD><BODY><P>If there is a key linking the two qvd's then you can join them and use a If statement.</P></BODY></HTML> Thu, 16 Feb 2017 16:00:09 GMT https://community.qlik.com/t5/QlikView/Referencing-fields-from-two-different-QVDs/m-p/1291359#M403722 aarkay29 2017-02-16T16:00:09Z